|
|
Re: coping one schema to another schema [message #37535 is a reply to message #37520] |
Wed, 13 February 2002 07:34 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
Use exp/imp. Be aware of UNLIMITED TABLESPACE/RESOURCE privs. Create the user:
create user USERNAME identified by PASSWORD
default tablespace def_tbsp
temporary tablespace temp
quota unlimited on def_tbsp;
grant connect to USERNAME;
grant create procedure to USERNAME;
grant create trigger to USERNAME;
grant create type to USERNAME;
alter user USERNAME quota 0M on system;
Do not grant RESOURCE. Do a user level export on the source schema:
exp userid=system/password owner="SOURCE_SCHEMA"
Then Import:
imp userid=system/password fromuser="SOURCE_SCHEMA" touser"TARGET_SCHEMA" IGNORE=Y
|
|
|