topic Delete Activiti Table rows without dropping table in Alfresco Archive

Delete Activiti Table rows without dropping table

thysmichels — Tue, 05 Aug 2014 22:54:27 GMT

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?

Re: Delete Activiti Table rows without dropping table

martin_grofcik — Wed, 06 Aug 2014 04:28:08 GMT

Hi,

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

Regards
Martin

Re: Delete Activiti Table rows without dropping table

thysmichels — Wed, 06 Aug 2014 22:50:09 GMT

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>