Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to rename a tablespace ?

Re: Is it possible to rename a tablespace ?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 25 Aug 2003 09:17:47 -0700
Message-ID: <1efdad5b.0308250817.42b179d9@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.




see my post below. this is why we update TS$ before we do the export.
Then we name it back in the staging server.
Received on Mon Aug 25 2003 - 11:17:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US