Creating Partitions

7.7.1.2 Creating Partitions

To create partition names, use the formats in the following table:

Table 7-18 Partition Name Formats

Partition Type Format and Description

Monthly

Partition Type	Format and Description
Monthly	PYYYYMM where YYYY is the four-digit year and MM is the two-digit month for the data in the partition. For example: Data for November 2006 resides in partition P200611. Note:The Data Retention Manager uses information in the `KDD_CAL` table to determine end-of-week and end-of-month boundary dates.
Weekly or Daily	PYYYYMMDD where YYYY is the four-digit year, MM is the two-digit month, and DD is either the date of the data (daily) or the date of the following Friday (weekly) for the data in the partition. For example: Data for November 30, 2006 resides in partition P20061130. Data for the week of November 19 - November 23, 2006 resides in partition P20061123. Note:The Data Retention Manager uses information in the `KDD_CAL` table to determine end-of-week and end-of-month boundary dates.

PYYYYMM

where YYYY is the four-digit year and MM is the two-digit month for the data in the partition.

For example:

Data for November 2006 resides in partition P200611.

Note:The Data Retention Manager uses information in the KDD_CAL table to determine end-of-week and end-of-month boundary dates.

Weekly or Daily

PYYYYMMDD

where YYYY is the four-digit year, MM is the two-digit month, and DD is either the date of the data (daily) or the date of the following Friday (weekly) for the data in the partition.

For example:

Data for November 30, 2006 resides in partition P20061130.

Data for the week of November 19 - November 23, 2006 resides in partition P20061123.

Note:The Data Retention Manager uses information in the KDD_CAL table to determine end-of-week and end-of-month boundary dates.

Note:

Data Retention Manager assesses the current status of partitions on the specified table to determine the requested partition. If the system previously fulfilled the request, it logs a warning message.

The Data Retention Manager does not support multiple partition types on a single table. If an Oracle client wants to alter the partitioning scheme on a table, that client must rebuild the table using the new partitioning scheme prior to utilizing the Data Retention Manager. Then you can update the values in the Data Retention Manager tables to reflect the new partitioning scheme.