Partition Data Load Staging Tables

Use the Partition Data Load Staging Table script to select a table partitioning option when loading large volumes of data. Table partitioning addresses inconsistent data load times, and enables table partitioning to isolate each data load process in a table partition.

Note:

Run the Partition Data Load Staging Tables script only when no other data load processes are running.

To partition data load staging tables:

  1. From the Data Integration home page, and then from the Actions menu, then from the Other actions drop-down, select System Maintenance Tasks.

  2. Click Image shows the Arrow icon. to the right of the Partition Data Load Staging Tables task.

  3. From the Run Script: Partition Data Load Staging Tables page, from Mode, select the partition table option.

    Available options:

    • Enable—Classifies a table in the cloud version of the Oracle Autonomous Database as "STAGING" and enables partitioning.

    • Revert—Turns off table partitioning.

  4. Click OK.