RE: Stored Procedure Distribution
- From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- To: <kedeshpande@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 May 2005 15:25:06 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kirtikumar Deshpande
Sent: Wednesday, May 18, 2005 3:06 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
