System requirements for database partitioning
There are system requirements that must be met before you can use database partitioning.
Database partitioning has the following requirements:
- Support for partitioning on the database server. Consult with your database administrator to determine whether your database supports partitioning.
- Set the following database permissions:
- ALTER TABLE
- DROP TABLE
- CREATE INDEX
- DROP INDEX
- ALTER INDEX
- CREATE TABLE
- Database disk space. When partitioning is done, the existing tables are renamed and data from each of the existing tables is copied back to the partitioned table. After all the data from the old table is copied to the partitioned table, the old table is dropped.
- Before you convert your production database tables to partitioned tables, back up your existing production database.