Strangest thing, when trying to query this table, I recieve this
error. When I look the table up in dba_objects and dba_tables, it is
there and is valid. If you describe the object, its description is
shown. It is not a nested or object table, just a simply table with
one composite unique index. Can not run analyze table validate
structure command, you recieve the 08103 error, I can not perform an
export of the table, same error, When I run db_verify against the
datafiles where the table resides, there are no errors shown on the
datafiles.
When I perform a select * from table, it will run up till the 159579
row, then bombs with the 08103 error. If I run a select column1,
column2 from table, where column 1 and 2 are the index columns, it
will run and return 311396 rows, which is the total row count of the
table.
I understand the index data is returned from the index leaf blocks,
but I don't understand what has happened to my table's data blocks. I
can create another table using the create table as select * from table
where rownum <159579; but I want to know what happened and what else I
might could do to recover the entires tables data. I don't have an
export of just the table and the database is nearly 300 GB, so I don't
have the luxury of building another database from backups, then export
the table from the backup.
Anyone's help or ideas would be appreciated.
~Jim
Received on Sun Nov 14 1999 - 19:50:17 CST
