DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: recover procedures from the dmp file

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Is it posible for me to recover the procedures from the dump file ???

    Please advise with the command of how to recover them

    Thanks

  2. #2
    Join Date
    Feb 2001
    Posts
    203
    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.

    sree

  3. #3
    Join Date
    Dec 2001
    Posts
    221
    you will have to import the whole schema in dummy database and then extract the procedure from that.
    Santosh Jadhav
    8i OCP DBA

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width