The Set Loader application also uses a temporary table and this table is located in the target schema. This table will contain one entry for every rule which executes and is used to record the progress of the load. It is also used to assist with restarts if an error should occur during the load process. The name of the loader set temporary table is DTB_LSTATS.
Note that since most of the rules in a loader set are manager rules each visible rule in the loader set actually contains multiple other rules. For example, a Disable Trigger Manager rule will list all of the triggers in the target schema. Each trigger represents a rule which will disable the trigger and hence there will be one entry in the DTB_LSTATS recording the disable status of that particular trigger.
Important note: The DTB_LSTATS temporary table is always truncated at the start of each new loader set run. The table is not truncated if the loader set is restarted. Once the load has completed, the temporary table can be truncated or dropped unless a restart operation is required.
The temporary table can be created automatically using the tools on the Loader Options tab of the Edit Rule Controller form. The Edit Rule Controller form can be activated by double clicking on the appropriate Rule Controller in the Set Designer application. The definition of the DTB_LSTATS temporary table is shown below. It may well be desirable to add an storage clause to size this table appropriately.
DROP table DTB_LSTATS; CREATE table DTB_LSTATS ( runmarker number, ruleid number(6), pruleid number(6), tid number, tname varchar2(65), deltamarker number, ucount number(38), status char ); ALTER TABLE DTB_LSTATS ADD CONSTRAINT PK_DTB_LSTATS PRIMARY KEY (runmarker,ruleid,pruleid) USING INDEX;