Re: Export n Import Users

In article 42d_at_raffles.technet.sg, Loy Huey Peng <loyhp_at_po.pacific.net.sg> writes:
> Hi there.
> I have 2 Ora7.1 accts, abc & xyz. Each has its own default tablespace,
> abcdata & xyzdata respectively.
> I exported the entrie contents (tables, views, procedures etc) of abc
> using the exp command.
> I then tried to import this dump file into xyz's acct. However, the
> problem I have is that the tables being recreated into xyz are
> still kept in abcdata. I even tried the fromuser=abc & touser=xyz
> parameters but without luck.
> What did I do wrong?
> Please help. I'm already stuck in this for 3 full days now.
> Thank you.
>

Hello,

If you make quota of xyz on abcdata 0, the import will create the database objects in xyzdata which is the default tablespace. (alter user xyz quota 0 on abcdata) Also remember to revoke unlimited tablespace from public to make this quota enforcement work.

Ravi. dba_temp1_at_nika.ebay.sun.com Received on Mon Jan 22 1996 - 00:00:00 CET