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: EXP/IMP to a different tablespace: has anyone been able to solve this?

Re: EXP/IMP to a different tablespace: has anyone been able to solve this?

From: <array7_at_inbox.com>
Date: Wed, 24 Oct 2007 14:47:28 -0700
Message-ID: <1193262448.274372.285090@q5g2000prf.googlegroups.com>


On Oct 24, 2:29 pm, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Tue, 23 Oct 2007 13:36:02 -0700, array7 wrote:
> > Is there a clean solution, or each time I need to mess with renaming all
> > tablespaces before imp and then renaming them back after imp?
>
> Renaming tablespaces???
>
> --http://www.mladen-gogala.com
>
> --http://www.mladen-gogala.com

Yes, like
alter tablespace ${src_tablespace} rename to ${src_tablespace}_buf; alter tablespace ${dest_tablespace} rename to ${src_tablespace};

...then run IMP, and after it rename everything back. Looks like an ugly method. Received on Wed Oct 24 2007 - 16:47:28 CDT

Original text of this message

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