Skip to Main Content
Forums

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!

Extracting the DDL(Code) of only stored procedures

MaxApr 28 2010 — edited Apr 28 2010
DB Version:11g

I have a list of Stored procedures (about 250) whose code ie. CREATE OR REPLACE STORED PROCEDURE statements i want to extract to a file.
Is there an option in imp or impdp where i can extract only the code of these stored procedures?

Apart from imp/impdp , is there any other way to do this?
This post has been answered by 591186 on Apr 28 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2010
Added on Apr 28 2010
#general-database-discussions
2 comments
8,238 views