Ora-01410, Invalid rowid Options

[fanfan]

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

[crottykt]

Well the format of the rowid is: block id, row in block, file id

Since you know the block id, you may be able to use a statement such as

delete from <table> where rowid like '<block id>%'

You can find more info here:

http://www.dba-oracle.com/t_ora_01410_invalid_rowid.htm

[fanfan]

I'm not doing insert or update on the table ,I only want to do a select on the table.My problem i don't know which block id was wrong.When I use the dba_extents view ,i find the block id for each datafile .My question ,what technic can help me found the invalid rows in the table ?My table has a lot of datafile and one tablespace and I use oracle 9i.

Thanks in advance for a solution

Well the format of the rowid is: block id, row in block, file id

Since you know the block id, you may be able to use a statement such as

delete from <table> where rowid like '<block id>%'

You can find more info here:

http://www.dba-oracle.com/t_ora_01410_invalid_rowid.htm

[Asad]

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.