How to rename a tablespace?

Is there a simple way to just rename a tablespace?
I see how to rename a tablespace's datafiles, but
not the tablespace itself. Any ideas?

Ans:
(My saying how to do it doen't mean full endorsement) You can connect as
SYS
and execute :
   update ts$
   set name = <new name>
   where name = <old name>;
   commit;
   alter system flush shared_pool;

If I were you, I would then shut the database down and start it up
again. Updating the dictionary is not recommended practice. In the case
of tablespaces, it is relatively safe because TS$ is the only table
where the name appears (tablespaces are referenced by their internal
number ts# everywhere else). I have done worse but don't mention this
kind of thing to the Oracle support, they are going to faint. And once
again, keep this kind of operation as a last resource attempt when you
have a big problem. Otherwise it would be better, if slower, to export
everything in the tablespace, drop it (including contents) and recreate
it under the new name.

Stéphane Faroult
Oriole Corporation

Hosted by www.Geocities.ws