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 PostgreSQL database.
- Oracle EE users:
Future partitions for an Oracle database are created automatically on the first of every month. For existing users, the create partitioning procedures might already be in place.
For users creating an instance of the database, run the following two scripts under $OM_HOME/samples/db_scripts/oracle after the initial tablespace and user are set up:
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. TheOMS_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 weekly, this procedure creates five partitions for the 1st, 7th, 14th, 21st, and 28th day of every month. - PostgreSQL users:
For PostgreSQL users, no additional steps are needed to create future partitions. The database creates a partition automatically if one does not exist in the database before saving relevant information in that partition.