2011-12-07

script to check baddata (number or varchar2 ) in the oracle database

Baddata Script To Check Database For Corrupt column data [ID 428526.1]

Check also this note/post : http://oradbastuff.blogspot.com/2011/11/typ2-len1-192.html

This script can be useful in case of the following errors :

Note:94185.1   - ALERT: JDBC Drivers May Insert Invalid Year 2000 Dates
Note:91207.1   - Warning for Client Code which directly manipulates Oracle DATE datatype values
Note:979657.8  - OCI allows invalid numbers to be inserted into the database
Note:4338390.8 - JDBC clients can insert corrupt data


The script can be downloaded here:
  Notepart:428526.1:BADDATA

Niciun comentariu:

Trimiteți un comentariu