OraFAQ Forum: Server Administration » renaming the shchema name while exporting

Home » RDBMS Server » Server Administration » renaming the shchema name while exporting

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

renaming the shchema name while exporting [message #199736]

Thu, 26 October 2006 01:33

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

Is there any way that i can rename the schema name while exporting the schema using export commnad

Report message to a moderator

Re: renaming the shchema name while exporting [message #199740 is a reply to message #199736]

Thu, 26 October 2006 01:38

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

[code]
try like below
Schema "Scott"

1.cmd>exp scott/tiger ( exp Scott Schema )
2.Create New Schema with New Name.
3.Drop Scott Schema. ( if you done successfully Export)
4.Imp Scott schema in New User Schema.

cmd>imp "newuser/pwd" fromuser=scott touser=newuser. ( prior to 10g.)
in 10g use "SCHEMAS" CLAUSE.see doc for more info.

Report message to a moderator

Re: renaming the shchema name while exporting [message #199742 is a reply to message #199736]

Thu, 26 October 2006 01:46

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

Senior Member
Account Moderator

>> Is there any way that i can rename the schema name while exporting the schema using export commnad
NOPE.
You cannot rename the schema while exporting.
But while importing you can import anywhere you want.
see user52's example.
Please search forum before posting. This is probably asked a zillionth time.

Report message to a moderator

Previous Topic:	Creating New database
Next Topic:	DBMS_STATS, VLDB and limited window

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:44:25 CDT 2024