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!
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.