I got ” ORA-01410 invalid ROWID ” error in Oracle database.
ORA-01410 invalid ROWID
Details of error are as follows.
ORA-01410 invalid ROWID Cause: A ROWID was entered incorrectly. ROWIDs must be entered as formatted hexadecimal strings using only numbers and the characters A through F. A typical ROWID format is '000001F8.0001.0006'. Action: Check the format, then enter the ROWID using the correct format. ROWID format: block ID, row in block, file ID.
SELECT URL, LOCAL, STRIPPED_VAL FROM SYS.KU$_XMLSCHEMA_VIEW ;
ORA-01410: invalid ROWID
The KU$_XMLSCHEMA_VIEW is in VALID status. SQL> select owner, object_type, status from dba_objects where object_name='KU$_XMLSCHEMA_VIEW'; OWNER OBJECT_TYPE STATUS ------------------------------ ------------------- ------- SYS VIEW VALID The same issue can also be reproduced by running - select '1' from resource_view where any_path = '/xdbconfig.xml';
This ORA-01410 error is related to the ROWID was entered incorrectly. ROWIDs must be entered as formatted hexadecimal strings using only numbers and the characters A through F. A typical ROWID format is ‘000001F8.0001.0006’.
XDB status may be INVALID in DBA_registry or it could be due to XDB metadata corruption.
Following two possible solutions.
++ Reload the XDB.
SQL> spool xdbreload.log SQL> connect / as sysdba SQL> set echo on; SQL> shutdown immediate; SQL> startup upgrade; SQL> @?/rdbms/admin/xdbrelod.sql SQL> shutdown immediate; SQL> startup; SQL> @?/rdbms/admin/utlrp.sql SQL> spool off
++ Or Reinstall XDB as per the below note
Oracle XML Database (XDB) Install / Deinstall [ID 1292089.1]
Second case’s solution is to Rebuild the indexes for the Oracle tables.
120 views last month, 3 views today