Re: Ora 01410 Invalid rowid(Urgent)

Thanks for your input.I have opened a TAR. Thanks and Regards,
Ashish

In article <_zgY5.748$JE.106561_at_nntp3.onemain.com>,   "Barbara Kennedy" <barbken_at_teleport.com> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 09 2000 - 04:48:43 CST