OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Copy Schema (Oracle 10.2.0.3 on Solaris 10)

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

Copy Schema [message #361286]

Tue, 25 November 2008 12:51

Lucky A
Messages: 68
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.

Report message to a moderator

Re: Copy Schema [message #361287 is a reply to message #361286]

Tue, 25 November 2008 12:53

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

Senior Member
Account Moderator

Export.
Exp or expdp.
With exp, rows=n compress=n

Report message to a moderator

Re: Copy Schema [message #361288 is a reply to message #361286]

Tue, 25 November 2008 12:55

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Additionally, DBMS_METADATA.GET_DDL package.

Report message to a moderator

Re: Copy Schema [message #362282 is a reply to message #361286]

Mon, 01 December 2008 12:32

Lucky A
Messages: 68
Registered: October 2007

Member

Thanks for your input.

Report message to a moderator

Previous Topic:	ORA 01503 create controlfile failed
Next Topic:	errors in Alert Log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 24 11:34:15 CST 2025