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: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Fri, 19 May 2006 13:30:09 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C29076D@enhbgpri05.backup>


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
<http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.co m/evt=39666/*http://messenger.yahoo.com> and save big.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 19 2006 - 12:30:09 CDT

Original text of this message

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