Is it posible for me to recover the procedures from the dump file ???
Please advise with the command of how to recover them
There are three modes of export -
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.
you will have to import the whole schema in dummy database and then extract the procedure from that.
8i OCP DBA
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