DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    export procedures and functions


    Is there a way to export procedures and functions only. I have asked this question to several experts and they all say that it is not possible. Currently I have to create the same procedures and functions on different databases. I am using Oracle


  2. #2
    Join Date
    Dec 2001
    it is not possible to take dump of only procedures and functions using export utility.

    However if you want the script, you can do it other way. If you know which procedure/function name or may be all procedures/functions. you can get the script using user_source dictionary table
    Santosh Jadhav
    8i OCP DBA

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.