on 06-03-2008 7:52 PM
Hi,
I'm having this error when update statistics is run:
+BR301E SQL error -1031 at location stats_tab_collect-3+
+ORA-01031: insufficient privileges+
+ORA-06512: at "SYS.DBMS_STATS", line 10301+
+ORA-06512: at "SYS.DBMS_STATS", line 10315+
+ORA-06512: at line 1+
The SAP was using the analyze table and I have changed to use DBMS_STATS. And now is returning this error.
Any Idea ?
Many Thanks.
Hi Rui,
Take a look at "Note 351163 - Creating ORACLE DB statistics using DBMS_STATS".
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rui,
You can install latest Oracle patch from sap.service.com, also. I faced with that kind of problem and I remember that I solved this issue by applying latest patches.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SAP Note 761745 - Oracle 9: ORA-01031 and ORA-06512 with DBMS_STATS s a very good starting point
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.