RE: HELP URGENT CORRUPTED DATA

From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
To: "Paula Stankus" <paulastankus@xxxxxxxxx>, "Freeman, Donald" <dofreeman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 19 May 2006 13:52:13 -0400
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@xxxxxxxxx] 
        Sent: Friday, May 19, 2006 1:45 PM
        To: Freeman, Donald; oracle-l@xxxxxxxxxxxxx
        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@xxxxxxxxxxx> 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@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.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>
RE: HELP URGENT CORRUPTED DATA

Other related posts:
