-
Dear Sir,
I get the error when I give the query
desc plan_table;
when Iam connected as internal
MGR_00360
Also the following are the errors I see in the alert log for the jobs that I set for analysing the schemas??
Errors in file D:\oracle\admin\dsm2\bdump\dsm2SNP0.TRC:
ORA-12012: error on auto execute of job 8
ORA-20000: user 'paris' does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 326
ORA-06512: at line 1
Thu Aug 01 04:14:31 2002
Errors in file D:\oracle\admin\dsm2\bdump\dsm2SNP1.TRC:
ORA-12012: error on auto execute of job 9
ORA-20000: user 'georef' does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 326
ORA-06512: at line 1
Thu Aug 01 04:14:31 2002
Errors in file D:\oracle\admin\dsm2\bdump\dsm2SNP3.TRC:
ORA-12012: error on auto execute of job 10
ORA-20000: user 'dms' does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 326
ORA-06512: at line 1
Kindly give your suggestions at the earliest
Regards,
K.Diwakar
-
Probably you have created the plan table with other user? Create it as internal and create a public synonym for it and try again.
Cheers
Angel
-
Diwakar,
In which schema have u created the jobs? The user in which u r creating the schema shud either have sysdba privs(and must be connected as sysdba) or
grant analyze any to user;