4. Managing Tables and Views : Table Management : Techniques for Moving a Table to a New Location
 
Share this page                  
Techniques for Moving a Table to a New Location
As a database grows, it can become necessary to move some of its tables to an alternate location. If a table has grown so large that you can no longer work with it at the current location, or the table needs to be distributed across multiple disks to improve performance, modify the table to use an alternate location.
Note:  Before modifying the table, make sure you have met the requirements, as described in Requirements for Using an Alternate Location for a Table (see page Requirements for Using an Alternate Location for a Table).
You can modify a table's location using one of the following techniques:
• Relocate a table
• Reorganize a table
In VBDA, use the Modify Table Structure dialog. For a detailed procedure, see online help. For other uses of this dialog, see the chapter “Maintaining Storage Structures.”