Re: Duplicate inserts but only through sqlplus

The solution has already been proctored, but I thought I would give one more piece.

Oracle does what you tell it to do...no more and no less. If you are getting data inserted twice, its because you told Oracle to insert it twice (as we have found out in this case). Similarly, if data gets deleted, its because someone (or some app) deleted it. Oracle does not randomly delete data. And Oracle does not randomly update data either. So if the values changed some application or someone forced the change.

I can't tell you how many times in my career someone has asked my why Oracle was mysteriously deleting/adding/updating data. My reply has always been the same...because it was instructed to do so. Quit telling Oracle to do what you don't want it to do, and it won't do it any more. For instance, I once had a developer ask my why data was getting lost in their tables. They would come in the next day and their data would be gone. Damned Oracle for losing their data! Come to find out, some poorly written scheduled script was deleting data from tables (used an OR in the WHERE clause of a DELETE stmt when it should have been an AND clause). Fixed the script and problem solved.

This was not meant as advice to the OP, as I'm pretty sure the OP knew that something was amiss in what he was telling SQL*Plus to do, but just advice in general.

Cheers,
Brian

--

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown

--

Posted via a free Usenet account from http://www.teranews.com Received on Thu Apr 12 2007 - 11:56:19 CDT