Copying a package from one schema to another

[Jeronimo]

Hi!

Suppose that a package x belongs to a schema, say 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!
Jeron

P.S.: I don't have the SQL Loader.

 

[carp]

Try exporting the package from SCOTT and importing with FROMUSER=scott and TOUSER=liz. [sig][/sig]

 

[connectxyzzy]

Couldn't you get the code out of all_source and run the resulting script under another schema (providing you have proper security)? [sig][/sig]