errors-plan_table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: errors-plan_table

  1. #1
    Join Date
    May 2002
    Posts
    193
    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

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  3. #3
    Join Date
    Jul 2002
    Posts
    132
    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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width