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 schedule the script to run now, see Scheduling a Job to Run Now.

To schedule the script to run later, see Scheduling a Job to Run Later.

When scheduling the Partition Data Load Staging Tables job, from Mode, specify the partition table option.

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

• Revert: Turns off table partitioning.