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).