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

Thread: export procedures and functions

  1. 11-09-2002, 04:07 AM #1
    burzinmk
    burzinmk is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 11-09-2002, 04:48 AM #2
    sjadhavdba
    sjadhavdba is offline Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width