Re: export from user to another user

Yes,

Make sure user2 doesn't have resource privilege, create table privilege should suffice.
Then make also sure the user has quota on the tablespace it should go to, and no quota on other tablespaces
(and users shouldn't have either unlimited tablespace privilege -included in the resource privilege- nor unlimited quota on the system tablespace) by issuing the following commands
alter user user2 quota unlimited on <desired tablespac>; alter user user2 quota 0 on <unwanted tablespace>;

Hth,

Sybrand Bakker, Oracle DBA

PS Make sure no pl/sql in the user1 schema explicitly refers to the user1 schema by coding user1.tablename everywhere. Import isn't smart enough to change the pl/sql when importing. Code like this should be changed before the import. Ran into this recently myself.

zoux_at_exchange.nih.gov wrote:

> Hi,
>
> Does anyone know how to export all data from one user to another user's
> default tablespace?
>
> I ran the export/import utility. For example:
> exp73 userid=dba/dba owner=user1
> imp73 userid=dba/dba fromuser=user1 touser=user2
>
> The problem is after running imp73, Oralce does not put imported data into
> user2's default table space. It just used the same tablespace user1 uses. Is
> it possible put imported data into user2's default table space?
>
> Thanks.
>
> zou
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Mon Mar 08 1999 - 12:46:18 CST