Home » RDBMS Server » Server Administration » renaming the shchema name while exporting
renaming the shchema name while exporting [message #199736] Thu, 26 October 2006 01:33 Go to next message
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

Re: renaming the shchema name while exporting [message #199740 is a reply to message #199736] Thu, 26 October 2006 01:38 Go to previous messageGo to next message
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.


Re: renaming the shchema name while exporting [message #199742 is a reply to message #199736] Thu, 26 October 2006 01:46 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: Creating New database
Next Topic: DBMS_STATS, VLDB and limited window
Goto Forum:
  


Current Time: Sat Dec 10 06:40:50 CST 2016

Total time taken to generate the page: 0.19067 seconds