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
All kinds of ways to do everything... here is 1 option.
Create user B with a default tablespace of Tablespace B and quota on Tablespace B.
Make sure user B does not have Quota on Tablespace A and does not have the "Unlimited Tablespace" system privilege.
You will have to do imp with fromuser and touser specified.
The imp will need to be executed with a DBA privileged account (or with the special imp role/priv that is in the DBA role).
-- "Thana" <yim_cm_at_hotmail.com> wrote in message news:cc349e63.0402070927.1f2cafc7_at_posting.google.com...Received on Sat Feb 07 2004 - 12:45:11 CST
> 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