ORA-01410 with Index Organized Tables IOT
My BI team is preparing to integrate a new database into their system. The new database is Oracle 11.2.0.2 (soon to be upgraded to 11.2.0.4) running on Linux. The BI team uses rowid and ora_rowscn for incremental change data capture from Oracle databases. They have brought a table to my attention that raises ORA-01410 with this query:
select ROWIDTOCHAR ( rowid ) as src_rowid, ora_rowscn, a.* from API.DOMAINLIST a; ORA-01410: invalid ROWID 01410. 00000 - "invalid ROWID"
Thinking this indicated a corruption problem, I was preparing to use dbms_redefinition to move the table to a new tablespace. I tested the redefinition process in a non-production environment, it worked, and I reran the query expecting success, only to get the error once again on the newly rebuilt table.