-
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
-
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
-
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
-
-
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...
-
schema manager and create like..
give the user name.
the purpose will be solved
-
Maybe DBMS_METADATA.GET_DDL might get at it? It can certainly get Functions and Procedures and the like.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|