Copy of a workflow package.pkb and .pkh from production database

I need to make a copy of a particular workflow_pkg.pkb and workflow_pkg.pkh from my production database. How do I do this? Please help.
k3vsmithAsked:
Who is Participating?
 
MikeOM_DBACommented:
In TOAD:

1) Select the owner schema from top-left drop down.
2) Select the package from the list (or drop down).
3) Click on "Script"
4) Right-click on the code or click on the "copy to clipboard (or editor window)
6) Paste (or copy + paste) into your text editor.
:p
Or...as was posted: From SQL*Plus session use the DBMS_METADATA package to get the DDL for that package.
0
 
k3vsmithAuthor Commented:
Im using Toad and have privileges...
0
 
flow01Commented:
search for the  dbms_metadata package  to get  package definitions

and probably you can also view the source in toad , copy / paste into a text file ,
may be add a "create or replace"  statement and use the text file to create the package in another database
0
 
k3vsmithAuthor Commented:
Perfect thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.