Moving Packages [message #7906] |
Wed, 16 July 2003 12:07 |
Shak
Messages: 13 Registered: May 2002
|
Junior Member |
|
|
Hi People,
I am trying to move packages from a development box to a test box.
Say I have 45 updated packages in dev box A to be moved to test box B how do I do that. I currently use the create and replace option for each package. Is there a shorter version of doing so .
Thanks in advance.
|
|
|
Re: Moving Packages [message #7907 is a reply to message #7906] |
Wed, 16 July 2003 13:51 |
sverch
Messages: 582 Registered: December 2000
|
Senior Member |
|
|
Save your packages on your drive, write a script like
@c:your_subdirectoryyour_package_name1
@c:your_subdirectoryyour_package_name2
@c:your_subdirectoryyour_package_name3
Save this script under your_script_name
Then from SQL*PLUS:
SQL> @C:your_subdirectoryyour_script_name
|
|
|