RE: Distributed transactions (two-phase commint) without DB links

Tom,

You said: "The more I dig into the current database that I'm troubleshooting the less I appreciate non-standard, if brilliant, approaches."

Let me just say, I *hate* clever brilliant approaches compared to standard straightforward approaches to problem solving. Clever & brilliant to me mean just what you said - somebody else's "nightmare" long after the person has left, while straightforward documented processes are much easier to maintain.

Tom

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

From: Thomas Day [mailto:tomday2_at_gmail.com] Sent: Tuesday, March 15, 2005 10:07 AM
To: oracle-L_at_freelists.org
Subject: Re: Distributed transactions (two-phase commint) without DB links

It seems to me a case of "You pays your money and you picks your poison."

You have institutional standards (and an institutional body of knowledge) for OCI in applications. As long as the standards don't change and the knowledge isn't lost it looks as if it will work fine for you.

In other institutions, where contractors come and go on an annual basis, I would think that DB links are more widely understood and easier to implement and troubleshoot.

The more I dig into the current database that I'm troubleshooting the less I appreciate non-standard, if brilliant, approaches. Remember, long after you're gone, someone is going to have to maintain the work that you did.
--

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

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 15 2005 - 10:40:23 CST