Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Changing tablespaces on IMP?
dean wrote:
> Is it possible to change the tablespaces of the tables during an
> import, from their original ones? Right now when we import a schema
> from our clients, to bring the data down to out test servers, we have
> to watch the error messages from the tablespace not existing, create
> the tablespaces, and then try again.
>
> Oracle 9.2i, 10g v 1 and 2. Windows, Sun, Linux.
>
> Thanks
>
> Dean
>
If you use expdp and impdp (Datapump) on 10g databases you can map the
source and destinations tablespaces :) and much faster :)
regards,
pedro
Received on Wed Feb 28 2007 - 15:29:07 CST