SAP Knowledge Base Article - Preview

3062263 - DB13 update statistics -BR0301W SQL error -942 at location BrTabModifRead-4 - after upgrade

Symptom

DB13 update statistics fails with the below issue after kernel update:

BR0301W SQL error -942 at location BrTabModifRead-4, SQL statement:
'OPEN curs_106a CURSOR FOR'
'SELECT TABLE_OWNER, TABLE_NAME, NVL(PARTITION_NAME, ' '), NVL(INSERTS, -1), NVL(UPDATES, -1), NVL(DELETES, -1), TRUNCATED, NVL(DROP_SEGMENTS, 0) FROM DBA_TAB_MODIFICATIONS WHERE TABLE_OWNER LIKE 'SAP%' AND TABLE_OWNER NOT IN ('SYS', 'SYSTEM') AND TABLE_N
ORA-00942: table or view does not exist


Read more...

Environment

Oracle database

Keywords

KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.