Try OpenEdge Now
skip to main content
Managing Table Partitioning in Databases
Managing Table Partitioning in a Database : Enabling a database for table partitioning
 

Enabling a database for table partitioning

You can enable a database for table partitioning from the Database Administration Console.
To enable a database for table partitioning:
1. Select Database Administration > Database Connections. The list of database connections appears.
2. Highlight the database connection of your choice from the list of database connections, and click View. The database home page appears.
3. Verify the Table Partitioning status in the Database Features panel.
Note: You can click the Sort arrow to display the features in ascending or descending order. If the status displays a check mark in a green circle and the word Enable does not appear in the Action column, the database is already enabled for table partitioning.
4. Click Enable. The Enable Table Partitioning page appears.
5. Click Enable table partitioning. A message confirms that the database is enabled for table partitioning.
6. Click OK.
Note: You can use the Database Features panel to enable Read-only Partitions in the same way. This option allows you to create read-only partitions using the current database connection.