Home » RDBMS Server » Server Administration » Copy Schema (Oracle 10.2.0.3 on Solaris 10)
Copy Schema [message #361286] Tue, 25 November 2008 12:51 Go to next message
Lucky A
Messages: 65
Registered: October 2007
Member
Hi,

I need to copy a schema (not the data) from the development database to the production database. The schema does not exist in production. What is the best aproach? Any suggestions would be helpful.


Thanks,

Lucky.
Re: Copy Schema [message #361287 is a reply to message #361286] Tue, 25 November 2008 12:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Export.
Exp or expdp.
With exp, rows=n compress=n
Re: Copy Schema [message #361288 is a reply to message #361286] Tue, 25 November 2008 12:55 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Additionally, DBMS_METADATA.GET_DDL package.
Re: Copy Schema [message #362282 is a reply to message #361286] Mon, 01 December 2008 12:32 Go to previous message
Lucky A
Messages: 65
Registered: October 2007
Member
Thanks for your input.
Previous Topic: ORA 01503 create controlfile failed
Next Topic: errors in Alert Log
Goto Forum:
  


Current Time: Wed Dec 07 04:57:14 CST 2016

Total time taken to generate the page: 0.06820 seconds