Re: Ora 01410 Invalid rowid(Urgent)

If there are no indexes on the table,
and the table is a standard (heap)
table, then the error message cannot
apply to the table itself.

1410 has to be telling you that a
rowid has been found that cannot
be converted to a legal table row.

I would __guess__, therefore, that this is telling you that you have some corruption in the data dictionary.

To check this, you could try setting sql_trace on and re-running the SQL, then check the trace file to see if the error occurs at a particular point in the recursive SQL.

You might then want to go a little further and run with event 10046 at level 4 so that you can see the bind values used in the recursive SQL. This may allow you to identify the actual data that is causing the problem.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



ashish25_at_my-deja.com wrote in message <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.