SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Copy package/procedure from one schema to another schema

New RootsJun 8 2015 — edited Jun 9 2015

Dear All,

I've two schema's in a single database. I've to copy all the procedures from schema A to scfhema B.Is there any easy way to copy only packages and procedures? If there is any exsting code please let me know.

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

"CORE 11.2.0.1.0 Production"

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

Regsards,

S.Balraj

This post has been answered by New Roots on Jun 9 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2015

Added on Jun 8 2015

10 comments

6,951 views