Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP URGENT CORRUPTED DATA

RE: HELP URGENT CORRUPTED DATA

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Fri, 19 May 2006 10:44:49 -0700 (PDT)
Message-ID: <20060519174449.27676.qmail@web33210.mail.mud.yahoo.com>


Yes,    

  Would using ANSI function help find the "hidden" data or comparing good tables to bad where it "looks" like the data is the same but somehow must not be? :)

"Freeman, Donald" <dofreeman_at_state.pa.us> wrote:

      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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula Stankus Sent: Friday, May 19, 2006 1:19 PM
To: oracle-l_at_freelists.org
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 and save big.                 

Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1&cent;/min.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 19 2006 - 12:44:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US