nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

How to delete all act tables data that is configured with Oracle.

monika_b

Hi, I have configured my Activiti with Oracle DB. I have tested this table performing few activiti implementations that populated act tables.

I want to delete all the data persisting in ACT tables. Deleting the child references then parent is troublesome. Is there some existing DML script that I can use for clean up of activiti tables?

Please help.

Find more posts tagged with

Comments

martin_grofcik

Hi Monika.

to drop tables you can use:

<br>drop table ACT_GE_PROPERTY cascade constraints;<br>drop table ACT_RU_VARIABLE cascade constraints;<br>drop table ACT_GE_BYTEARRAY cascade constraints;<br>drop table ACT_RE_DEPLOYMENT cascade constraints;<br>drop table ACT_RU_IDENTITYLINK cascade constraints;<br>drop table ACT_RU_TASK cascade constraints;<br>drop table ACT_RE_PROCDEF cascade constraints;<br>drop table ACT_RU_EXECUTION cascade constraints;<br>drop table ACT_ID_MEMBERSHIP cascade constraints;<br>drop table ACT_ID_GROUP cascade constraints;<br>drop table ACT_ID_USER cascade constraints;<br>drop table ACT_ID_INFO cascade constraints;<br>drop table ACT_RU_JOB cascade constraints;<br>drop table ACT_HI_PROCINST cascade constraints;<br>drop table ACT_HI_ACTINST cascade constraints;<br>drop table ACT_HI_TASKINST cascade constraints;<br>drop table ACT_HI_DETAIL cascade constraints;<br>drop table ACT_HI_COMMENT cascade constraints;<br>drop table ACT_HI_ATTACHMENT cascade constraints;<br>drop table ACT_RU_EVENT_SUBSCR cascade constraints;<br>

in the qa module

Regards
Martin

monika_b

Thanks Martin. This is a very useful script. But still actually I required the script to clean up activiti data preserving the tables.

Though: I got deleted one by one already checking child constraint eachtime. Still a script will be very useful.

jbarrez

Programmatically, you could query *all* deployments, loop over them and delete them setting the 'cascade' option to true. That would effectively remove all data in your db.

monika_b

Thanks jbarrez. Would use this logic when require in future.

jbarrez

No, no sql script. The engine can do it for you though.

karrahahu1

Deleting the child references then parent is troublesome. Is there some existing DML script that I can use for clean up of activiti tables????