Oracle data and Y2K tool

From: Peter Merks <pwmerks_at_ibm.net>
Date: 1997/11/29
Message-ID: <01bcfc84$60b52c60$72a32581_at_dbsun.dbcorp.ab.ca>#1/1


I'm looking for a tool/utility with the ability to be set-up and run against a large number of Oracle databases. I want it to find things like all the date columns, any dates that are entered in with invalid centuries.  As well look at any other columns that are potential candidates to contain date sensitive data and search for any of these and report these back. ie columns with date in the name, or time or DT. Its all part of a compliance effort, and as a dba I want to be able to quickly identify 'locations' in the database that have suspect date data and pass these back to application groups. I could write my own pl/sql or small app to do this but am looking to see if there are commercial applications already out there. Ideally the program would also have the ability to search for other data or relationships.

thanks,
Pete Merks Received on Sat Nov 29 1997 - 00:00:00 CET

Original text of this message