Re: Ora 01410 Invalid rowid(Urgent)

In our last gripping episode ashish25_at_my-deja.com wrote:
> 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.
>

If the table structure cannot be validated there is no hope of saving it outside of dropping it and importing it from a recent export. If you haven't a recent export of this table I believe, as Howard puts it, you are "stuffed".

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.