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

Thread: re: exporting a stored procedure

  1. #1
    Join Date
    Jan 2004
    Posts
    58

    Unhappy re: exporting a stored procedure

    hi! ,


    Is there any way to export just one stored procedure from one user
    to the other ...

    thanks
    thanks,
    harish

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Not using Oracle's imp/exp - a 3rd party tools like SQL Navigator allow you to get the DDL for procs that can be cut n pasted and run in as a different user

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Yes, drop all objects that the user owns except for the desired procedure and then peform the schema level export. Then import fromuser/ to user.

    Or the short answer to your question is no
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Feb 2004
    Posts
    35
    All_Source

  5. #5
    Join Date
    May 2001
    Location
    London
    Posts
    149
    The best way I think is:

    Import the user in some "TEST" user without data...and then take the code of the procedure from user_source table...

  6. #6
    Join Date
    Apr 2003
    Posts
    353
    schema manager and create like..
    give the user name.

    the purpose will be solved

  7. #7
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Maybe DBMS_METADATA.GET_DDL might get at it? It can certainly get Functions and Procedures and the like.

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    needs to be 9+
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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