Before you can begin partitioning your database, you must complete the following prerequisites:

  • Identify tables to partition

    Identify the new and existing tables that you want to partition and their associated partition columns and local and global indexes.

  • Allocate space for the tables being partitioned

    Create a structure description (.st) file to allocate space for the tables being partitioned.

  • Enable table partitioning for a database

    Enable table partitioning for the database using the Database Administration Console.