Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

13.13.7 Splitting or combining a table containing a non-partitioning key index

If a table contains a non-partitioning key index that does not correspond on a one-to-one basis to the table RDAREAs, that table cannot be split or combined.

Procedure
  1. Delete the non-partitioning key index.
  2. Unload the table data from the RDAREAs to be split or combined.
  3. Use ALTER TABLE to specify boundary values or the RDAREA to be split.
  4. Use the database load utility to load data from the unload data file created in step 2 into the split or combined RDAREAs.
  5. Redefine the non-partitioning key index.