Siebel Enterprise Integration Manager Administration Guide > Deleting Data > Editing the Configuration File for Delete Processing >
Deleting All Data Rows
If you want to delete all data rows in a target base table, you must perform the following procedure. Typically, this would only be performed in a test environment. To delete all rows in a target base table
- Set the delete all rows parameter in the EIM configuration file to true; its default value is false.
The following example contains lines that can be used in the EIM configuration file to delete all rows from the accounts table:
[Delete Accounts] TYPE = DELETE BATCH = 200 TABLE = EIM_ACCOUNT DELETE ALL ROWS = TRUE
CAUTION: Use the DELETE ALL ROWS = TRUE setting with extreme caution. It will indeed delete all rows in the target base table.
|