Solution : https://service.sap.com/sap/support/notes/633914 (SAP Service marketplace login required)
Summary :
Errors encountered while using Oracle DBMS_STATS package typically stem from incorrect usage or configurations leading to various Oracle error codes like ORA-00904 for invalid column names or ORA-01031 for insufficient privileges, among others. The resolution involves several steps depending on the specific error: correcting column names, ensuring sufficient user privileges, or updating Oracle patches for known bugs. Errors such as ORA-04067 can occur if the package is not properly installed or if a necessary component, like the SYS.DBMS_STATS body, is missing. Ensuring the package is correctly set up and that all prerequisites are met is crucial for addressing these issues.
Key words :
components bc-db-ora-dba database administration, oracle priority recommendations / additional info category, customer component bc-db-ora oracle, failed psaptemp sparse file extension, inconsistent oracle ddic 548221 temporary files, / __%pdfstyle%__font-size, __%pdfstyle%__ / } symptom, br tools 948197 merge fix, manage database statistics results, sparse files 12741 current versions
Related Notes :
| 963760 | 'ORA-20000: Insufficient privileges' for creating statistics |
| 948197 | Merge fix for DBMS_STATS package on Oracle 9.2.x and 10.2.x |
| 761745 | Oracle 9: ORA-01031 and ORA-06512 with DBMS_STATS |
| 684545 | Statistics generation: DBMS_STATS runs longer than ANALYZE |
| 613872 | Oracle traces with ORADEBUG |
| 582427 | Error due to inconsistent Oracle DDIC |
| 548221 | Temporary Files are created as sparse files |
| 12741 | Current versions of BR*Tools and SAPDBA |
| 731 | Collective note: ORA-00904 |