RE: Stored Procedure Distribution

It depends on your security setup and so on of what you are able to do.

We establish a common user across db and create a script to login and update all the dbs from a single server using sqlplus. (I am referring to unix)

Another slower way would be to create an export and push to all the servers with an auto ftp script etc.

In old days.. I used to do it by a sqlnet and just cut and pasted for an hour or two and
Install that way using common user (or not)

This should be pretty basic stuff though.

Brian

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kirtikumar Deshpande
Sent: Wednesday, May 18, 2005 3:06 PM
To: oracle-l_at_freelists.org
Subject: Stored Procedure Distribution

Hi All,
 My boss asked me to find out following:   What is your experience in distributing a large number of stored procedures, functions etc to a large number of databases?

  He is looking for time saving tips, typical problems one may encounter and steps taken to solve those, any automation ideas to handle this. (We currently do not use OEM).  

  That's all the information I have. Sorry, if this is not enough.   

 I will fwd all responses to him and have him directly contact you if he has any more questions. Hope you won't mind. Because, I am at Oracle Corp this week (testing 10g R2) and will be off to India next week.

 Thanks.

 Cheers!

• Kirti

Discover Yahoo!
Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 18 2005 - 15:29:52 CDT