Analyze Table failed
I have issued an dbms_stats.gather_table_stats command:
exec dbms_stats.gather_table_stats('USER1','Table1',cascade => TRUE);
But I am getting the following error:
BEGIN dbms_stats.gather_table_stats('USER1','Table1',cascade => TRUE); END;
*
ERROR at line 1:
ORA-20000: Unable to analyze TABLE "USER1"."TABLE1", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 13172
ORA-06512: at "SYS.DBMS_STATS", line 13202
ORA-06512: at line 1
The privileges should be there since all other tables owned by this user analyzed fine.
I query the database and the table does exist. My only suspision is that the table name 'Table1'. Do I need to use double quote for this to work? I will give it a try and see what happens.