errors-plan_table

[diwakar]

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

[aarroyob]

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

[soniaarora]

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;