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: Imp from user to user with change tablespace

Re: Imp from user to user with change tablespace

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 07 Feb 2004 10:33:00 -0800
Message-ID: <xbaVb.36180$P17.7296@fed1read03>


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

Original text of this message

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