Database Administration (MOSC)

MOSC Banner

Analyze Table failed

edited Jul 13, 2011 5:24AM in Database Administration (MOSC) 2 commentsAnswered
My database is 10.2.0.3 on solaris 10

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center