Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-20000: Unable to analyze TABLE "XXCXX"."XXTXX", insufficient privileges or does not exist

User_6FB2MSep 24 2020

i am geeting error in 19c database

EXEC DBMS_STATS.GATHER_TABLE_STATS('XXXX','XXX');SQL>

BEGIN DBMS_STATS.GATHER_TABLE_STATS('XXXX','XXX'); END;

*

ERROR at line 1:

ORA-20000: Unable to analyze TABLE "XXCXX"."XXTXX",

insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 36897

ORA-06512: at "SYS.DBMS_STATS", line 36520

ORA-06512: at "SYS.DBMS_STATS", line 36740

ORA-06512: at line 1

Comments
Post Details
Added on Sep 24 2020
5 comments
8,207 views