Database Reference
In-Depth Information
• Increase the database storage. This may not be a long term option but
eventually you will run out of storage if your application has a large num-
ber of BPELs.
• Execute the PL/SQL procedures provided by Oracle. Ensure that all the
following listed Dehydration tables are included in the data purging pro-
cess:
•
CUBE_INSTANCE
•
CUBE_SCOPE
•
INVOKE_MESSAGE
•
DLV_MESSAGE
•
WORK_ITEM
•
SCOPE_ACTIVATION
•
DLV_SUBSCRIPTION
•
AUDIT_TRAIL
•
AUDIT_DETAILS
•
WFCOMMENTS
•
WFATTACHMENT
•
WFMESSAGEATTRIBUTE
•
WFASSIGNEE
•
WFTASKMETADATA
•
WFTASK
•
DLV_MESSAGE_BIN
•
INVOKE_MESSAGE_BIN
•
PROCESS_DESCRIPTOR
•
WI_EXCEPTION
•
XML_DOCUMENT
Please note the default purge script provided by Oracle is not sufficient to delete all
the data from the dehydration store. Please ensure that you delete the data from all
of the preceding tables to clean up the database. The other option is to delete the
database schemas and recreate it using RCU without changing the schema name or
password.