Re: Ora 01410 Invalid rowid(Urgent)

You might try an export of the table. Sometimes an export will fail and give you an error message on the bad row. I have been able to delete the offending row and export the entire table minus the row. Not good, but better than nothing. Sometimes the export error message will give you all the values except one of the columns (the bad one). In that case I wrote them down, deleted the row, and inserted the row with all the values except 1.

Jim
<ashish25_at_my-deja.com> wrote in message news:90rlv7$8ju$1_at_nnrp1.deja.com...
> Hi,
> I am getting this error on doing a select from one of the tables.No
> index on that table.Table has been truncated couple of times in Past.
> Running on Oracle 8.1.6.1.0 Linux 2.2.14.
> Already did this
> 1)Analyze table validate structure cascade -> Failed
> 2)Ran dbv on files OK
> 3)Tried to get data from this table
> create table new_table as select * from old table failed.
>
> Any ideas ???.No trace nothing in alert.log so I am clueless.
> What could have caused it and how do I salvage the table.
> Thanks and Regards,
> Ashish
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 08 2000 - 20:15:06 CST