re: HELP URGENT CORRUPTED DATA

  • From: Paula Stankus <paulastankus@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 19 May 2006 10:18:30 -0700 (PDT)

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.

Other related posts: