Rename Tablespace

Until 10g, this is not really possible, although you can create a staging tablespace etc.

However in 10g, use the following simple command and it works a treat.

ALTER TABLESPACE "old tablespace name " RENAME TO "new tablespace name";