Creating or Updating Table Partitions

When you access the Table Partitions page, it might display a log that lists tables that contain more than 500 thousand rows, or it might display one of the following messages:

No tables available. This message indicates that partitioning is enabled; however, there are no tables that currently exceed 500 thousand rows.
Permissions to create table partitions. If this message is displayed, particularly if you are using an on-premises environment, it indicates that you do not currently have the applicable user permission in the Oracle database schema for Unifier to create partitions. You must have the select permission for the v$option and gv$sql_monitor tables. For more information, contact your systems or database administrator.
Table partitioning is not enabled. If this message is displayed, particularly if you are using an on-premises environment, it indicates that partitioning is not enabled for your Oracle database. For more information, contact your systems or database administrator.

If there are tables that contain more than 500 thousand rows, the log lists information for each applicable table such as the name of the BP, an indication of whether the table is for a BP or a line item, a status that indicates whether the table has been partitioned, and so on.

When you create a partition, the system evaluates the selected table and provides suggestions based on the following:

Number of Rows in the Selected Table	Recommended Number Partitions	Maximum Number of Partitions
>=500K and <1M	4	8
>=1M and < 5M	8	16
>=5M and <10M	16	32
>=10M and <50M	32	64
>=50M and 1B	64	128
>=1B and 5B	128	256
>=5B	256	256

After you have partitioned a specific table, you have the option at a later time of redistributing the data across the recommended number of partitions or selecting a higher number of partitions. This is known as repartitioning.

To create a table partition:

Go to the Company Workspace tab and switch to Admin mode.
In the left Navigator, select Data Structure Setup, and then select Table Partitions.
In the Table Partitions log, review the list of tables carefully before continuing.
As explained earlier, only the tables for Simple and Line Item BPs defined at the project/shell level are currently available for partitioning, partitioning cannot be reversed, and performance improvement is dependent on how your BPs are designed.
Select the table that you want to partition, and click Create Partitions.
In the Choose number of partitions dialog box, click Continue to accept the recommended number.
The system checks the unique ID numbers for the table and evaluates the information based on the table provided earlier. It then selects the number of partitions based on what is smaller; for example, if the number recommended for the row count is 16, but the number of unique ID numbers is 9, the recommended partition number is 8. You can choose a different option from the list instead of accepting the recommended selection.
When the Create partitions confirmation message appears, review the statements.
If you are ready to continue, click Create; otherwise, click Cancel.
If a selected table is currently in use for another reason, such as a configuration package or BP package is being deployed, the system displays a message that indicates partitioning cannot be completed at this time. When you know that the other activity has completed, you can try creating the partition again.

After partitioning commences, you can monitor its progress. For more information, see Monitoring Table Partitions. When partitioning completes successfully or an error occurs, the systems sends and email to the user who initiated the partitioning request.

Note: If a partition job is in progress for a BP table, you cannot deploy a related BP design until the partition job completes or fails.

To update (repartition) a table partition:

Go to the Company Workspace tab and switch to Admin mode.
In the left Navigator, select Data Structure Setup, and then select Table Partitions.
In the Table Partitions log, select the table that you want to partition again, and click Repartition.
If the selected table cannot be repartitioned, the system displays a message.
In the Repartition dialog box, click Repartition to accept the recommended number.
When the Repartition confirmation message appears, review the statements.
If you are ready to continue, click Create; otherwise, click Cancel.

See Also