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!

How to Deploy Store Procedure to production server

717846Aug 18 2009 — edited Aug 18 2009

Hi All,

I want to move and upgrade more than 10 packages and 12 procedures from my test server to production server. There are 7 Db servers I want to update. I am doing this by manually open the package then paste the proc contents then compile .So it take me a lot of time. I would like to know any deployment Procedures. Then I can save time. Maybe like batch files or any....

Thank you for your time and concern
DBMS:Oracle 10g
App server OS:Microsoft 2003 server
database server :Linux
Db tool: pl/slq developer
Application :Asp.net Technology

Regards

Jim.

This post has been answered by Boneist on Aug 18 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 15 2009

Added on Aug 18 2009

#deployment

13 comments

935 views