I recently had to face such a problem. For those who give up, the answer is below 🙂 exec dbms_Stats.gather_schema_stats(‘TESTSCHEMA’); ERROR at line 1:ORA-20000: Schema ” TESTSCHEMA” does not exist or insufficient privilegesORA-06512: at “SYS.DBMS_STATS”, line 38330ORA-06512: at “SYS.DBMS_STATS”, line 38289ORA-06512: at “SYS.DBMS_STATS”, line 8593ORA-06512: at “SYS.DBMS_STATS”, line 38172ORA-06512: at “SYS.DBMS_STATS”, line 38317ORA-06512: at line […]