Database Administration (MOSC)

MOSC Banner

dbms_stats.gather

edited Jul 2, 2012 7:51AM in Database Administration (MOSC) 7 commentsAnswered

HI

How to Resolve this this issus?

exec dbms_stats.gather_schema_stats(ownname =>'HPATT',cascade=>true,estimte_percent=>dbms_stats.auto_sample_size);

 

 

SQL> exec dbms_stats.gather_schema_stats(ownname =>'HPATT',cascade=>true);

BEGIN dbms_stats.gather_schema_stats(ownname =>'HPATT',cascade=>true); END;

 

*

ERROR at line 1:

ORA-20000: Schema "HPATT" does not exist or insufficient privileges

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

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

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

ORA-06512: at line 1

Any help highly appericated.

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