OraFAQ Forum: Server Administration » how to copy a schema

Home » RDBMS Server » Server Administration » how to copy a schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to copy a schema [message #180457]

Mon, 03 July 2006 11:40

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

how to copy a schema using IMP/EXP between differant servers..

Thanks

Report message to a moderator

Re: how to copy a schema [message #180458 is a reply to message #180457]

Mon, 03 July 2006 11:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://orafaq.com/faq/import_export

Report message to a moderator

Re: how to copy a schema [message #180460 is a reply to message #180458]

Mon, 03 July 2006 11:46

sreehari
Messages: 101
Registered: May 2006

Senior Member

when i give the following command,, it is exporting all the schemas in the database..where i want to copy only scott schema..

EXP SCOTT/TIGER@HOSTSTRING FILE=FULL.DMP LOG=FULL.LOG FULL=Y

help on this is greatly apprecialted...

Thanks

Report message to a moderator

Re: how to copy a schema [message #180463 is a reply to message #180460]

Mon, 03 July 2006 11:56

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

ofcourse it does. FULL=Y does that.
Please search the forum/documentation.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm

You need to user owner=Scott

exp scott/tiger@host file=mydmp.dmp owner=scott

while importing

import scott/tiger@host file=mydmp.dmp fromuser=scott touser=anotherscott

Report message to a moderator

Previous Topic:	Not able to login with SYS user
Next Topic:	Questions..?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:42:17 CDT 2024