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. Click Application, then Jobs, and then Schedule Jobs.

  2. From the Schedule Jobs page, then What type of job is this?, select Integration Maintenance Script.

  3. To schedule an integration maintenance script to run now, see Scheduling Hourly Jobs .

    To schedule an integration maintenance script to run later, see Scheduling a Data Rule or Integration Definition to Run Later in the Job Scheduler.

  4. Click Next.

  5. From Integration Maintenance Script page, click Image shows Select icon. to the right of the Partition Data Load Staging Tables task to schedule.

  6. 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.

  7. Click OK.