Extracting Data from a Corrupt Table using ROWID scans

From: <deebeeay_at_gmail.com>
Date: 21 Jun 2005 01:57:17 -0700
Message-ID: <1119344237.502617.235550@g14g2000cwa.googlegroups.com>

Hi,

Can anyone help me explain what's happening here? (Names changed to protect the innocent)

select /*+ INDEX_FFS (X INDEX) */
a,b,c from TABLE X
where rowid >= 'AAAAeDAAkAAAJq6AAA'
and rowid < 'AAAFizAANAAC1K4AAA'

ERROR:
ORA-01578: ORACLE data block corrupted (file # 13, block # 742071) ORA-01110: data file 13: '/oracle.data'

SQL> select /*+ full(T) */ a,b,c from TABLE T   2 where rowid >= 'AAAAeDAAkAAAJq6AAA'   3 and rowid < 'AAAFizAANAAC1K4AAA'
; 4
ERROR:
ORA-01578: ORACLE data block corrupted (file # 13, block # 742071) ORA-01110: data file 13: '/oracle.data'

 SQL> select /*+ full(T) */ a,b,c

  2  from TABLE     /**************************** No T ????????????? */

  3 where rowid >= 'AAAAeDAAkAAAJq6AAA'   4 and rowid < 'AAAFizAANAAC1K4AAA'
; 5

<snip>

17 rows selected.

So I didn't supply the alias for TABLE and it brings back data? This is Oracle 8.0.6 if it helps.

Cheers
Dee Received on Tue Jun 21 2005 - 03:57:17 CDT