OraFAQ Forum: Client Tools » How to replicate a package in one database to other database

Home » Other » Client Tools » How to replicate a package in one database to other database (PLSQL DEVELOPER version 9.0 WINDOWS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to replicate a package in one database to other database [message #594946]

Wed, 04 September 2013 06:31

9390512774
Messages: 103
Registered: January 2011
Location: hyd

Senior Member

Hi Tech's

I have a package called getEmpData in database orcl. I want to move/creat the same package on other database called ora. I want to do/simplyfy this work through PLSQL DEVELOPER.

Thanks in advance.

Report message to a moderator

Re: How to replicate a package in one database to other database [message #594947 is a reply to message #594946]

Wed, 04 September 2013 06:48

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

don't you have the script for the package in source control?

Report message to a moderator

Re: How to replicate a package in one database to other database [message #594952 is a reply to message #594946]

Wed, 04 September 2013 07:29

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

9390512774 wrote on Wed, 04 September 2013 17:01

I want to do/simplyfy this work through PLSQL DEVELOPER.

In PL/SQL Developer, in the object view, right click and open the package as "EDIT SPEC AND BODY" in program window. Then log off the session and connect to other DB. In the same program window, just compile the package. If required do a tweak or two to change the schema name etc.

Report message to a moderator

Re: How to replicate a package in one database to other database [message #595595 is a reply to message #594952]

Thu, 12 September 2013 04:39

pradip.tk
Messages: 3
Registered: July 2013
Location: India

Junior Member

Other option is, you can extract the code from user_source or from dbms_metadata and compile it in the other database.

Pradeep

[Updated on: Thu, 12 September 2013 04:39] by Moderator

Report message to a moderator

Previous Topic:	How to Open PL/SQL DEVELOPER with SQL WINDOW from command line
Next Topic:	No Semi-colon used in buffer editor Sqlplus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:35:47 CST 2025