Can anyone explain to me how to rename a tablespace ? Thank you in advance.
asked
Can one rename a tablespace?
No, this is listed as Enhancement Request 148742.
Workaround: Export all of the objects from the tablespace Drop the tablespace including contents Recreate the tablespace Import the objects
You didn't mention in your original posting which version of Oracle you are using.
In Oracle 9i, unfortunately you do indeed need to create a tablespace with the correct name and then move the existing object to it.
Starting in 10g, the following syntax is supported:
ALTER TABLESPACE tbs01 RENAME TO tbs02;
Hope this helps.
