Solution : https://service.sap.com/sap/support/notes/662644 (Connexion à SAP Service Marketplace requise)
Résumé :
ORA-00942 error occurs when a database object is inaccessible, caused by the object's nonexistence or insufficient user permissions. To resolve this, first identify the statement causing the error, obtainable from logs like Developer traces (ST11) or tool-specific logs. Next, check the database to confirm the object’s presence using a provided SQL command, ensuring the object name is fully capitalized. Solutions range from correcting SQL commands, confirming object ownership, verifying permissions, to SAP-specific adjustments such as validating the SAPDBA role or correcting dictionary script imports. Comprehensive approaches have been suggested based on whether the error lies with manual SQL usage, SAP tools, or insufficient privileges.
Mots Clés :
terms db02 st04 brbackup brarchive brconnect brrestore brtools brrecover brspace brgui xpl reason, manually execute sql statements, sql> connect sapr3/sapconnected, existsql> desc sapr3, individual reason, complex bw query, sql> desc t000, sysdbasql> desc t000, execute monitoring jobs, relevant log file
Notes associées :
| 736313 | ORA-00942 when accessing Oracle dictionary tables |
| 700548 | FAQ: Oracle authorizations |
| 641630 | |
| 640553 | Database error during explain: ora-1039 ora-905 ora-942 |
| 582427 | Error due to inconsistent Oracle DDIC |
| 519832 | |
| 496165 | ORA-00980/ORA-00942 on USER_IND_COLUMNS |
| 400241 | Problems with ops$ or sapr3 connect to Oracle |
| 134592 | Importing the SAPDBA role (sapdba_role.sql) |
| 15033 | |
| 12741 | Current versions of BR*Tools and SAPDBA |