Can anyone explain to me how to rename a tablespace ? Thank you in advance.
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.
No one has followed this question yet.