Home » SQL & PL/SQL » SQL & PL/SQL » coping one schema to another schema
coping one schema to another schema [message #37520] Tue, 12 February 2002 22:00 Go to next message
sufiyan
Messages: 2
Registered: February 2002
Junior Member
Hi,

can any body tell me, how to transfer one schema to another schema.

i mean i make a copy a schema in another schema.

Thanks

Sufiyan

Report message to a moderator

Re: coping one schema to another schema [message #37522 is a reply to message #37520] Wed, 13 February 2002 00:15 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

what u want to copy.. table ,index etc....can u clarify

cheers
pratap

Report message to a moderator

Re: coping one schema to another schema [message #37535 is a reply to message #37520] Wed, 13 February 2002 07:34 Go to previous message
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

Report message to a moderator

Previous Topic: Temporary table alternative
Next Topic: explain plan
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 15:14:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.