Example:
ALTER TABLESPACE ts1 RENAME TO ts2;
However, you must adhere to the following restrictions:
- COMPATIBILITY must be set to at least 10.0.1
- Cannot rename SYSTEM or SYSAUX
- Cannot rename an offline tablespace
- Cannot rename a tablespace that contains offline datafiles
For older releases, use the following workaround:
- Export all of the objects from the tablespace
- Drop the tablespace including contents
- Recreate the tablespace
- Import the objects
No comments:
Post a Comment