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:52:13 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C060B9575@enhbgpri05.backup>


I have used dump before to find hidden carriage returns, linefeeds etc as:  

SELECT DUMP('abc', 1016)

   FROM DUAL; DUMP('ABC',1016)



Typ=96 Len=3 CharacterSet=WE8DEC: 61,62,63

SELECT DUMP(last_name, 8, 3, 2) "OCTAL"

   FROM employees
   WHERE last_name = 'Hunold';

OCTAL



Typ=1 Len=6: 156,157

SELECT DUMP(last_name, 10, 3, 2) "ASCII"

   FROM employees
   WHERE last_name = 'Hunold';

ASCII



Typ=1 Len=6: 110,111

I'll look back at my issue and re-figure out how I did it....

	-----Original Message-----
	From: Paula Stankus [mailto:paulastankus_at_yahoo.com] 
	Sent: Friday, May 19, 2006 1:45 PM
	To: Freeman, Donald; oracle-l_at_freelists.org
	Subject: RE: HELP URGENT CORRUPTED DATA
	
	
	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 <http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.com/evt=39666/*http://messenger.yahoo.com> and save big.         


        Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. <http://us.rd.yahoo.com/mail_us/taglines/postman7/*http://us.rd.yahoo.com/evt=39666/*http://messenger.yahoo.com>

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

Original text of this message

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