Re: Is it possible to rename a tablespace ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 24 Aug 2003 12:48:47 -0700
Message-ID: <2687bb95.0308241148.70dcf804@posting.google.com>

"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message news:<3f463902$1_1_at_news.estpak.ee>...
> > You might be able to use the transportable tablespace option of
> > exp/imp to perform most of the work for you.
>
> AFAIK, transportable tablespace feature requires tablespace names to remain
> the same.
>
> Tanel.

I think you are right, but there is a TABLESPACE= parameter that was introduced (I think) in conjunction with TRANSPORT_TABLESPACE that might be of use standalone on the export. Depending on the number of owners involved an import with the user predefined to default to the new tablespace or an import using preallocated objects sould be an option from the TABLESPACE= export.

HTH -- Mark D Powell -- Received on Sun Aug 24 2003 - 14:48:47 CDT