Database Administration (MOSC)

MOSC Banner

Need stats expert support

edited Jul 4, 2011 10:11PM in Database Administration (MOSC) 4 commentsAnswered ✓
 Hi,

while executing the import schema stats , we are facin the below error in one of our 9.2.0.6 DB on Solaris 5.8 build.

SQL> exec dbms_stats.import_schema_stats('ALPHA','STATS');
BEGIN dbms_stats.import_schema_stats('ALPHA','STATS'); END;

*
ERROR at line 1:
ORA-20000: Schema ALPHA does not exist or insufficient privileges to analyze an
object within it
ORA-06512: at "SYS.DBMS_STATS", line 4984
ORA-06512: at "SYS.DBMS_STATS", line 5007
ORA-06512: at "SYS.DBMS_STATS", line 5523
ORA-06512: at line 1
-

Please help us why I'm getting this error and how to overcome this?

-

Thanks

GPKris

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