Skip to Content
avatar image
Former Member

Error ORA-00942 in db13 -> UpdateStats

Hello Guys,

we experience one Error in two (QAS and Prod) of our ERP Systems.

When scheduling job UpdateStats in DB13 we got following error:

BR0301W SQL error -942 at location BrStatsJobCheck-1, SQL statement:

'SELECT COUNT(*) FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'GATHER_STATS_JOB' AND ENABLED = 'TRUE''

ORA-00942: table or view does not exist

I searched the notes but found only DBA_SCHEDULER_JOBS in association with Oracle 10g, but this is a Oracle 9.

Here are some additional informations :

Name Value

oracle_sid EAC

oracle_home /oracle/EAC/920_64

oracle_profile /oracle/EAC/920_64/dbs/initEAC.ora

sapdata_home /oracle/EAC

sap_profile /oracle/EAC/920_64/dbs/initEAC.sap

system_info eacadm/oraeac sap-eac-01 Linux 2.6.5-7.312-smp #1 SMP Fri Jun 6 13:44:33 UTC 2008 x86_64

oracle_info EAC 9.2.0.7.0 8192 925 114166660 sap-eac-01 UTF8 UTF8

sap_info 640 SAPSR3 EAC G0753333288 R3_ORA 0020103415

make_info linuxx86_64 OCI_102 Aug 19 2006

command_line brconnect -u / -jid STATS20081120112652 -c -f stats -t ALL

stats_table ALL

stats_change_threshold 50

stats_parallel_degree 1

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 20, 2008 at 12:58 PM

    Hi Macro,

    Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

    Action: Check each of the following:

    the spelling of the table or view name.

    that a view is not specified where a table is required.

    that an existing table or view name exists.

    Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.

    Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

    Regards,

    Rahul.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Rahul,

      Thanks for the answer, but this is the standart Updatestats which you can select in the DB13.

      Nothing is changed.

      So the question is, why use the brtools the DBA_SCHEDULER_JOBS Table, when it's only recognized in Oracle 10 (I think so)

      Thanks

      Marco

  • Nov 20, 2008 at 02:58 PM

    Seems like an error with the OPS$ Users.... read SAP Note 400241

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2009 at 11:11 AM

    Hu Guys,

    OPS$ user was correct.

    But we've found an incorrect installation of the whole systems.

    We've exported both systems and imported them again (homogenous Systemcopy).

    Now both systems are OK.

    Thanks

    a lot

    Add comment
    10|10000 characters needed characters exceeded