Partition Data Load Staging Tables

Use the Partition Data Load Staging Tables script to select the table partitioning option when loading large volumes of data.

Table partitioning feature 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 process only when no other data load processes are running.

Note:

Enabling table partitioning is not available for data loads in a local environment.

To execute the Partition Data Load Staging Tables script:

To execute the List Table Rowcount script:

1. On the Workflow tab, under System Maintenance Tasks, select Partition Data Load Staging Tables and then click Execute.

2. From the Execute Script page, in Value, select the partition data load staging tables mode.

   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.

3. Click OK.