Delete Activiti Table rows without dropping table

[thysmichels]

Is there a sql script to delete the Activiti Table rows without dropping the table?

If no what is the sequence to delete the tables?

[martin_grofcik]

Hi,

Following thread could help you:
http://forums.activiti.org/content/how-delete-all-act-tables-data-configured-oracle

Regards
Martin

[thysmichels]

The following works:
<code>
delete from ACTDICE.ACT_RU_VARIABLE ;
delete from ACTDICE.ACT_RU_IDENTITYLINK ;
delete from ACTDICE.ACT_RU_TASK ;
delete from ACTDICE.ACT_RU_EXECUTION ;
delete from ACTDICE.ACT_RU_JOB ;</code>