Purging BPEL dehydration store

In some cases you need to purge the contents of the BPEL dehydration store (cleanup development environment, etc). The following script truncates the relevant tables and releases the space allocated to them:

truncate table orabpel.cube_instance;
truncate table orabpel.cube_scope;
truncate table orabpel.work_item;
truncate table orabpel.wi_exception;
truncate table orabpel.document_ci_ref;
truncate table orabpel.document_dlv_msg_ref;
truncate table orabpel.scope_activation;
truncate table orabpel.dlv_subscription;
truncate table orabpel.audit_trail;
truncate table orabpel.audit_details;
truncate table orabpel.sync_trail;
truncate table orabpel.sync_store;
truncate table orabpel.dlv_message;
truncate table orabpel.invoke_message;
truncate table orabpel.ci_indexes;
truncate table orabpel.native_correlation;
truncate table orabpel.xml_document;
 
alter table orabpel.cube_instance deallocate unused;
alter table orabpel.cube_scope deallocate unused;
alter table orabpel.work_item deallocate unused;
alter table orabpel.wi_exception deallocate unused;
alter table orabpel.document_ci_ref deallocate unused;
alter table orabpel.document_dlv_msg_ref deallocate unused;
alter table orabpel.scope_activation deallocate unused;
alter table orabpel.dlv_subscription deallocate unused;
alter table orabpel.audit_trail deallocate unused;
alter table orabpel.audit_details deallocate unused;
alter table orabpel.sync_trail deallocate unused;
alter table orabpel.sync_store deallocate unused;
alter table orabpel.dlv_message deallocate unused;
alter table orabpel.invoke_message deallocate unused;
alter table orabpel.ci_indexes deallocate unused;
alter table orabpel.native_correlation deallocate unused;
alter table orabpel.xml_document deallocate unused;
 
alter table orabpel.cube_instance enable row movement;
alter table orabpel.cube_instance shrink space compact;
alter table orabpel.cube_instance shrink space;
alter table orabpel.cube_instance disable row movement;
 
alter table orabpel.cube_scope enable row movement;
alter table orabpel.cube_scope shrink space compact;
alter table orabpel.cube_scope shrink space;
alter table orabpel.cube_scope disable row movement;
 
alter table orabpel.work_item enable row movement;
alter table orabpel.work_item shrink space compact;
alter table orabpel.work_item shrink space;
alter table orabpel.work_item disable row movement;
 
alter table orabpel.wi_exception enable row movement;
alter table orabpel.wi_exception shrink space compact;
alter table orabpel.wi_exception shrink space;
alter table orabpel.wi_exception disable row movement;
 
alter table orabpel.document_ci_ref enable row movement;
alter table orabpel.document_ci_ref shrink space compact;
alter table orabpel.document_ci_ref shrink space;
alter table orabpel.document_ci_ref disable row movement;
 
alter table orabpel.document_dlv_msg_ref enable row movement;
alter table orabpel.document_dlv_msg_ref shrink space compact;
alter table orabpel.document_dlv_msg_ref shrink space;
alter table orabpel.document_dlv_msg_ref disable row movement;
 
alter table orabpel.scope_activation enable row movement;
alter table orabpel.scope_activation shrink space compact;
alter table orabpel.scope_activation shrink space;
alter table orabpel.scope_activation disable row movement;
 
alter table orabpel.dlv_subscription enable row movement;
alter table orabpel.dlv_subscription shrink space compact;
alter table orabpel.dlv_subscription shrink space;
alter table orabpel.dlv_subscription disable row movement;
 
alter table orabpel.audit_trail enable row movement;
alter table orabpel.audit_trail shrink space compact;
alter table orabpel.audit_trail shrink space;
alter table orabpel.audit_trail disable row movement;
 
alter table orabpel.audit_details enable row movement;
alter table orabpel.audit_details shrink space compact;
alter table orabpel.audit_details shrink space;
alter table orabpel.audit_details disable row movement;
 
alter table orabpel.sync_trail enable row movement;
alter table orabpel.sync_trail shrink space compact;
alter table orabpel.sync_trail shrink space;
alter table orabpel.sync_trail disable row movement;
 
alter table orabpel.sync_store enable row movement;
alter table orabpel.sync_store shrink space compact;
alter table orabpel.sync_store shrink space;
alter table orabpel.sync_store disable row movement;
 
alter table orabpel.dlv_message enable row movement;
alter table orabpel.dlv_message shrink space compact;
alter table orabpel.dlv_message shrink space;
alter table orabpel.dlv_message disable row movement;
 
alter table orabpel.invoke_message enable row movement;
alter table orabpel.invoke_message shrink space compact;
alter table orabpel.invoke_message shrink space;
alter table orabpel.invoke_message disable row movement;
 
alter table orabpel.ci_indexes enable row movement;
alter table orabpel.ci_indexes shrink space compact;
alter table orabpel.ci_indexes shrink space;
alter table orabpel.ci_indexes disable row movement;
 
alter table orabpel.native_correlation enable row movement;
alter table orabpel.native_correlation shrink space compact;
alter table orabpel.native_correlation shrink space;
alter table orabpel.native_correlation disable row movement;

alter table orabpel.xml_document enable row movement;
alter table orabpel.xml_document shrink space compact;
alter table orabpel.xml_document shrink space;
alter table orabpel.xml_document disable row movement;