recover procedures from the dmp file

[ashley75]

Is it posible for me to recover the procedures from the dump file ???

Please advise with the command of how to recover them

Thanks

[sree_sri]

There are three modes of export -
Table mode,
User mode,
Full Database.

Table mode exports specified tables and related triggers, constraints and comments.

User mode exports all objects (tables, indexes, procedures ...) in the specified user's schema.

Full database is self explanatory.

Hence, there is no option for exporting only procedures.

[sjadhavdba]

you will have to import the whole schema in dummy database and then extract the procedure from that.

[pando]

do
imp file=exp.dmp log=imp.log show=y

(use fromuser, touser or full whatever the mode you want)

then from imp.log you can extract the PL/SQL stmt to create the procedure