Relocate a Table
You can move the data files for a table from one location to another by using the MODIFY TO RELOCATE statement.
In VDBA, this is accomplished using the Modify Table Structure dialog. When the Relocate radio button is enabled, click the Locations button, which opens the Relocate Table dialog. For information on using this dialog, see online help.
Using this operation, it is possible to change one or more of the locations currently used by the table, without changing the number of locations used. For example:
• If a table is currently using a single location, choose a new location and the data files for the table are moved to the new location.
• If a table is currently using multiple locations, selectively specify which ones you want to change.