Copying a package from one schema to another

[Dan]

Hi!

Suppose that a package x belongs to the schema SCOTT. Now, I want to copy the entire package to another schema, say LIZ. Is there any command in sql for doing so, e.g. COPY SCOTT.X TO LIZ.X ?
Thanks for your help!
Dan

[markgriffin]

Dan,

If you arent aware there is a very good freeware developer tool called toad(www.toadsoft.com). This tool will allow you to 1). create different database logins within same toad session. 2). It has a procedure editor that will allow you to pull procedures, functions, packages.... by schema owner.

So you could create 2 database sessions(1st sess would be where your package is currently located, 2nd sess would be where you want to copy package to).

Load up procedure editor from session one, pull in you package, click blue button(menu bar). This action will select all code. Pull up procedure editor from session two. The click ctrl-v. Once code is in procedure editor(session two). then click compile.

Hope this helps.

[svk]

Use the Schema Manager of OEM.

Select the package under the original schema. Right click - Selct "Create like" and next will be self explainatory.

[carp]

Or, as I mentioned on an identical post you placed elsewhere, export the package, then import with fromuser=scott and touser=liz.

[Highlander]

If you looking for an eassy way to do this try to use the following script:

SET PAGESIZE 10000
SET feedback OFF
SET heading OFF
SET echo OFF
spool d:\SQL.OUT

SELECT TEXT
FROM USER_SOURCE
WHERE NAME = 'MY_PACKAGE';

spool OFF
SET echo ON
SET feedback ON
SET heading ON

CONNECT OTHER_USER/OTHER_PASSWORD@OTHER_DATABASE;

@d:\SQL.OUT