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. Complete the steps for scheduling a maintenance script.

    For more information, see Scheduling Maintenance Scripts in the Job Scheduler.

  2. From the Schedule Job page, select the Partition Data Load Staging Tables script and then click Next.

  3. From the 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.