Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Changing tablespaces on IMP?
On Feb 28, 4:29 pm, Pedro Lopes <pedro.lo..._at_netvisao.pt> wrote:
> 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
What does 'map the tablespaces' mean? Please elaborate, sounds interesting. Received on Wed Feb 28 2007 - 20:02:11 CST