RE: HELP URGENT CORRUPTED DATA
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <paulastankus@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 May 2006 13:30:09 -0400
Exactly what errors are you getting? I've had corruption which led to
characters being inserted into not null date and number fields and had a
heck of a time being able to select the row containing the bad data. I
can't remember the exact error but I was being told there was null data
in a not null column. I forgot that null means "unknown" and not
empty. Does this sound like anything you are experiencing? If it is
I'll dig around in the musty old emails and find out what was going on.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Paula Stankus
Sent: Friday, May 19, 2006 1:19 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: re: HELP URGENT CORRUPTED DATA
Guys,
We recovered a database, did a dbverify - everything looked
good, exports are working fine. However, we recovered to an earlier
point (few hours earlier) and on the "earlier" database we have no
errors in a specific function of the application in the "later" one we
have errors. We have been beating our hands against the brick wall
doing comparisons of the data - the comparisons - table by table, column
by column look okay. We have been working on this issue round-the-clock
for days.
Questions:
A-Can an index be somehow causing this problem and can we use
validate structure or something to be sure of the validity of the index?
- analyze table validate structure...cascade...
B-Can there be missing characters (characters we cannot visually
see) causing the problem and can a "MINUS" find it if there is? :)
Thanks,
Paula
_____
New Yahoo! Messenger with Voice. Call regular phones from your
PC
<http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.co
m/evt=39666/*http://messenger.yahoo.com> and save big.
Other related posts:
