Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP/IMP to a different tablespace: has anyone been able to solve this?
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
![]() |
![]() |