Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export stored procedure only

862105Jul 26 2011 — edited Jul 26 2011

Hi,

I need to export stored procedure only using expdp.
I use the include parameter.
(1) Should I use the exclude parameter to omit others?
(2) Should I stop the db before using expdp (or any other things)?
(3) Is the below stmt correct?

expdp user/pass directory=/export/home/mydir
dumpfile=sp.dmp
logfile=sp.log
schemas=mine
include=package,function,procedure

Thanks.

Edited by: 859102 on Jul 26, 2011 1:22 AM

Edited by: 859102 on Jul 26, 2011 2:01 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 23 2011

Added on Jul 26 2011

#general-database-discussions

7 comments

1,241 views