Need stats expert support
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