Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

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.
0
k3vsmith
Asked:
k3vsmith
  • 2
2 Solutions
 
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
 
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:
Perfect thanks!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now