Type | Description |
Basic | Trading Networks archives or deletes documents after a specified number of days. When Trading Networks archives a document, it copies the document from the production tables to the archive tables and then removes the document and references to the document from the production tables. When Trading Networks deletes a document, it removes all associated document information from both the production and archive tables. |
Extended | Trading Networks archives or deletes documents based on criteria you specify, such as the document ID, sender, receiver, and system status (for example, DONE, RESUBMITTED, or ABORTED). You can choose to archive only selected data in documents. You can choose to delete documents from the production tables, the archive tables, or both. You can also set the batchSize, which is the maximum number of documents that can be archived or deleted in a batch. |
Production Table | Archive Table |
BizDoc | ARCHIVE_BizDoc |
BizDocContent | ARCHIVE_BizDocContent |
BizDocAttribute | ARCHIVE_BizDocAttribute |
BizDocArrayAttribute | ARCHIVE_BizDocArrayAttribute |
BizDocRelationship | ARCHIVE_BizDocRelationship |
DeliveryJob | ARCHIVE_DeliveryJob |
ActivityLog | ARCHIVE_ActivityLog |
BizDocUniqueKeys | ARCHIVE_BizDocUniqueKeys |
EDITracking | ARCHIVE_EDITracking |
Note: | If Trading Networks repeatedly deletes data from an Oracle database, the database tables might become skewed. To resolve this issue, regenerate the statistics of the table. |