Partition Data Load Staging Tables

Select a table partitioning option when loading large volumes of data.

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. From System Maintenance page, click Image shows Select icon. to the right of the Partition Data Load Staging Tables task to schedule.

  3. From the Run Script: Partition Data Load Staging Tables page, and then 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.