From 10g, it is possible to rename tablespace (except SYSTEM and SYSAUX).
Alter Tablespace old_name rename to new_name
Example:
Alter tablespace BB_Data rename to ZZ_Data
Renaming UNDO Tablespace
Select value from v$spparameter where name = 'undo_tablespace' --> UNDOTBS1
Alter Tablespace UNDOTBS1 Rename to UNDOTBS2
Select value from v$spparameter where name = 'undo_tablespace' --> UNDOTBS2
No comments:
Post a Comment