export procedures and functions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export procedures and functions

  1. #1
    Join Date
    Oct 2002
    Location
    India
    Posts
    42

    export procedures and functions

    Hi

    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 9.0.1.1.1.

    Burzin

  2. #2
    Join Date
    Dec 2001
    Posts
    221
    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