Home » SQL & PL/SQL » Client Tools » How to replicate a package in one database to other database (PLSQL DEVELOPER version 9.0 WINDOWS)
How to replicate a package in one database to other database [message #594946] Wed, 04 September 2013 06:31 Go to next message
9390512774
Messages: 97
Registered: January 2011
Location: hyd
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.
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 Go to previous messageGo to next message
cookiemonster
Messages: 11089
Registered: September 2008
Location: Rainy Manchester
Senior Member
don't you have the script for the package in source control?
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2458
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.
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 Go to previous message
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:
  


Current Time: Fri Oct 31 10:46:37 CDT 2014

Total time taken to generate the page: 0.10022 seconds