Home » RDBMS Server » Server Utilities » export (Oracle 9i)
export [message #477249] Wed, 29 September 2010 13:39 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi Experts,
How to export the procedure,views,function and packages in a database, by using Export commmand.
Please provide me the code for this.
Thanks in advance.

Report message to a moderator

Re: export [message #477250 is a reply to message #477249] Wed, 29 September 2010 13:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1013411

Report message to a moderator

Re: export [message #477251 is a reply to message #477249] Wed, 29 September 2010 13:42 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't (if you meant ONLY these objects).
Use DBMS_METADATA.GET_DDL.

Regards
Michel

[Updated on: Wed, 29 September 2010 13:42]

Report message to a moderator

Previous Topic: export/import and NOVALIDATE constraints
Next Topic: sql loader, % conversion and $ removal
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:10:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.