OR 12.0 | Relocate Statement

System Reference Summary > System Reference Summary > Statements > OpenROAD SQL Statements > Relocate Statement

Was this helpful?

Relocate Statement

Is used to relocate tables. This statement moves a table from its current location to the area corresponding to the specified location_name. All indexes, views, and protections for the table remain in force and valid regardless of the location of the table.

Note: The relocate statement must be used when the current disk of the table becomes too full.

Syntax:

relocate table_name to location_name;

Last modified date: 06/25/2024