DBMS_STATS.get_prefs Returns ORA-20000: object does not exist or insufficient privileges
(Doc ID 2829184.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
SELECT DBMS_STATS.get_prefs Returns ORA-20000: object does not exist or insufficient privileges For Index
SQL> SELECT DBMS_STATS.get_prefs(ownname=>'TCX',tabname=>'CUST',pname=>'ESTIMATE_PERCENT') estimate_percent FROM dual;
ESTIMATE_PERCENT
--------------------------------------------------------------------------------
DBMS_STATS.AUTO_SAMPLE_SIZE
SELECT DBMS_STATS.get_prefs(ownname=>'TCX',tabname=>'CUST_ID_PK',pname=>'ESTIMATE_PERCENT') estimate_percent FROM dual;
SQL> SELECT DBMS_STATS.get_prefs(ownname=>'TCX',tabname=>'CUST_ID_PK',pname=>'ESTIMATE_PERCENT') estimate_percent FROM dual;
SELECT DBMS_STATS.get_prefs(ownname=>'TCX',tabname=>'CUST_ID_PK',pname=>'ESTIMATE_PERCENT') estimate_percent FROM dual
*
ERROR at line 1:
ORA-20000: TABLE "TCX"."CUST_ID_PK" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 50549
ORA-06512: at "SYS.DBMS_STATS", line 9081
ORA-06512: at "SYS.DBMS_STATS", line 50531
ORA-06512: at line 1
Symptoms
Select DBMS_STATS.get_prefs does not work in 12.2.0.1 and above when the object is an index.
Changes
Upgrade to 12.2.0.1
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |