Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Imp from user to user with change tablespace
Thana wrote:
> HI
> I try to imp from one schema to another schema. But I would like to change
> tablespace to keep them.
> how to exp from user A to user B with option move tablespace A to B.
> For example
> User A -- > Tablespace A
> move to user B -- > tablespace B
Just pre-create the (empty) tables in the new/desired tablespace & use IGNORE=YES option. Received on Sat Feb 07 2004 - 12:33:00 CST