Re: Is it possible to rename a tablespace ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 22 Aug 2003 06:42:47 -0700
Message-ID: <2687bb95.0308220542.400e9092@posting.google.com>

"Luigi" <LuiginospamMarzella_at_libero.it> wrote in message news:<jlj1b.257268$lK4.7950596_at_twister1.libero.it>...
> Dear all,
> I'd like to know if it's possible to rename a tablespace with Oracle 9i.
> Thanks a lot
> Luigi

I do not believe Orace supports any command to do this. I reviewed the 9.2 SQL manual entries for alter tablespace and the rename command, neither seem to support this.

As with versions 6 - 8.1 you have to create the new tablespace and migrate your objects to it.

You might be able to use the transportable tablespace option of exp/imp to perform most of the work for you.

HTH -- Mark D Powell -- Received on Fri Aug 22 2003 - 08:42:47 CDT