Database Administrator Guide > Database Administrator Guide > Managing Tables and Views > Table Management > Table Location
Was this helpful?
Table Location
When you create a table, it is placed in the default location designated for the database’s data files, unless you specify otherwise.
Requirements for Using an Alternate Location for a Table
Before using an alternate location for a table, the following requirements must be met:
• The location must exist and must be designated to hold data files
• The area to which the location name points must exist with correct permissions and ownership
• The directory indicated by the area must have the appropriate subdirectory structure with correct permissions
• The database must be extended to the location
• You must be the table owner (or a user with the security privilege impersonating the owner).
Alternate Location for a Table
To create a table in an alternate location, use the WITH LOCATION clause of the CREATE TABLE statement.
In Director, use the Options in the New Table tab. In VDBA, click Options in the Create Table dialog.
If you specify only one location, the entire table is stored in that location. If you choose more than one location, the table spans multiple locations. For example, if you designate two locations, the table is extended over two alternate locations. As rows are added to the table, they are added to each area in alternate blocks.
The blocks are:
Windows: 16-page blocks (approximately 32 KB)
UNIX: 16-page blocks (approximately 32 KB)
VMS: 8 pages (32 disk blocks)
The table is considered out of space if the next receiving area in turn does not have a sufficient block.
Note:  After creating a table, you can change its location, as described in Techniques for Moving a Table to a New Location.
Last modified date: 11/28/2023