Nonstop Database, HiRDB Version 9 System Operation Guide
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
- Delete the non-partitioning key index.
- Unload the table data from the RDAREAs to be split or combined.
- Use ALTER TABLE to specify boundary values or the RDAREA to be split.
- Use the database load utility to load data from the unload data file created in step 2 into the split or combined RDAREAs.
- Redefine the non-partitioning key index.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.