Adding Future Partitions to an Existing Database

The Oracle SE database does not support partitioning, this section assumes that the user has an Oracle EE or Postgres database.

  • Oracle EE users:

    Future partitions for an Oracle database are created automatically on the first of every month. For existing users, the create new partitioning procedures should already be in place.

    For users creating a new instance of the database, run the following two scripts under $AF_HOME/samples/db_scripts/oracle after the initial table space and user are setup:
    • OMS_Create_Future_Partitions_SQL_Monthly.sql
    • OMS_Future_Partitions_Monthly_JOB.sql

    The OMS_Create_Future_Partitions_SQL_Monthly.sql script saves a procedure called ORS_FUT_PART_WEEKLY in the database. The OMS_Future_Partitions_Monthly_JOB.sql script creates a job that kicks off at 1:00 a.m. on the first of every month. This job calls the ORS_FUT_PART_WEEKLY procedure to create a one month worth of future partitions. Since partitions are divided on a weekly basis, this procedure creates five partitions for the 1st, 7th, 14th, 21st and 28th day of every month.

  • Postgres users:

    For Postgres users, no additional steps are needed to create future partitions. The database creates a new partition automatically if one does not exist in the database before saving relevant information in that partition.