QUOTE (fanfan @ Jan 31 2008, 10:19 PM)
I have a table which is partitionning ,whenever I pass a query it said
invalid rowid(ora-01410)but it don't contains index.I make analyse over the tabler ,there are
no rows in the table invalid_rows.What I can do to repair this because we cannot
get data from the table.I create another table and use exchange partition to load the datas in the new table but it still say invalid rowid?
Can I use Rman to resolve it
What technic to use to check the invalid rowid,I have a lot of rows in
the table?.I have each block id by using the dba_extents ,how can I
find the rowid with the bloc id in order to find all invalid rows and drop them.
Thanks in advance
does this table has any foreign key?
please put up the query you're using with execution plan, and cut paste the error.