RE: Middle-Tier Inflicted Corruption

MacGregor, Ian A. scribbled on the wall in glitter crayon:

> Peoplesoft (in-the-head) in their ultimate wisdom decided not to use
> the date on the database server, but that on the client. I now have
> these incorrect dates sprinkled through the system. Furthermore some
> have propagated from parent to child. I spent most of the weekend
> mining redo logs and believe I have come up with a complete list of
> the effected rows. One cannot ever be 100% sure. The project
> leaders for each Peoplesoft module have these. They will be
> responsible for implementing any corrections

welcome to my world... well the world at my old job. been there, done that, it sux.     

> With database enforced RI I can find the lineage of a key through all
> generations, but that is not so easy when it is program based.
>
> I am open to suggestions as to how to best remedy this stituation

well there are two data dictionaries to worry about, Oracle's and PeopleSoft's. so make sure they're in sync. in my case we had dates that were way out of range, so i could scan the dates and find the wrong ones, then work on correcting them. [in my case the project leads wouldn't touch it with a ten foot pole.;-)]

write me off line with any questions if i can help.

--
Bill "Shrek" Thater     ORACLE DBA      
"I'm going to work my ticket if I can..." -- Gilwell song
                william.thater_at_carrier.utc.com
------------------------------------------------------------------------
Politics for the moment while an equation is for eternity. - Albert Einstein
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------