OraFAQ Forum: Server Utilities » EXPORT PROCEDURES,PACKAGES

Home » RDBMS Server » Server Utilities » EXPORT PROCEDURES,PACKAGES

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

EXPORT PROCEDURES,PACKAGES [message #326122]

Tue, 10 June 2008 04:50

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi to all,

In toad we can take a backup of procedures,packages,triggers etc.

How can we take backup of procedures,packages of a particular using export utility.

The database version is 10g Release 2.

I like to take only backup of procedures,packages,triggers etc not the data's in particular schema..

Thanks in Advance,

Seenu...

Report message to a moderator

Re: EXPORT PROCEDURES,PACKAGES [message #326123 is a reply to message #326122]

Tue, 10 June 2008 04:51

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Either use expdb or dbms_metadata.
You can't do it with exp.

Regards
Michel

Report message to a moderator

Re: EXPORT PROCEDURES,PACKAGES [message #326160 is a reply to message #326123]

Tue, 10 June 2008 06:55

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Will u please give me link to know more about expdp and dbms_metadata.

THANK U MICHEL,

Report message to a moderator

Re: EXPORT PROCEDURES,PACKAGES [message #326165 is a reply to message #326160]

Tue, 10 June 2008 07:12

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://tahiti.oracle.com
Click on your version
Put one keyword in the search field and click on Search button
Access the page
Go back to the previous page
Put the other keyword in the search field and click on Search button
Access the page

Regards
Michel

[Updated on: Tue, 10 June 2008 07:12]

Report message to a moderator

Previous Topic:	how to load data from several dat files at a time using sqlloader?
Next Topic:	problem while Importing dmp file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:46:37 CST 2024