ORA-01410 invalid ROWID

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 ;
ERROR:
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';

 

 

invalid ROWID

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]

 

OR

 

Second case’s solution is to Rebuild the indexes for the Oracle tables.

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 120 views last month,  3 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply