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 then, 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.
    This action enables table partitioning and as a consequence, read-only partitioning also is enabled, by default.
  6. Click OK.
    Note: You can also use the Database Features panel to know the status of the Read-only Partitions.