Database Administration (MOSC)

MOSC Banner

ORA-01410 with Index Organized Tables IOT

edited Mar 16, 2015 4:28PM in Database Administration (MOSC) 3 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center