Error ORA-00942 table or view does not exist while doing Oracle upgrade.

[former_member209962]

Dear All,

While doing oracle upgrade from 10.2.0.4 to 11.2.0.3 using Oracle Database Upgrade Assistant we got a error as Error  ORA-00942: table or view does not exist

We ignored this error and every thing went fine  and upgrade completed successfully and in the log it is mention that Error ignored: ORA-00942: table or view does not exist.

Is it OK to ignore this error or anything has to be done kindly suggest.

Thanks

Tabrez

[volker_borowski2]

Hi,

locate the error in the log and find the statement that cause it.

If that was a DROP TABLE or DROP VIEW that did fail, no prob.

In earlier days, you had a couple of scripts that did do

DROP TABLE ...

CREATE TABLE ...

in sequence, just to be able to restart the script. So when executed the first time,

the drop will always fail, and that is no problem in this case.

Meanwhile this sequence is syntactically replaced by

CREATE OR REPLACE TABLE ...

which will give no error any more if the object exists, but not all places in the

upgrade scripts might be corrected allready, so if you still have a sequence as

shown above, that is no problem at all.

If you get an -942 i.e. for a CREATE VIEW, because an underlying table does not exist,

or for other reasons, you need to investigate deeper.

Volker

[Former Member]

Hi,

As per my knowledge during oracle upgrade you will get two Oracle errors: ORA-32006, ORA-32004 which you can ignore. Other errors should be cheeked thoroughly

Please run oradict_stats , system_stats & standard update statistics. These will give you the clear picture.

SAP Note 588668 - FAQ: Database statistics

Please let me know the result.

BR

Rajat

[Former Member]

Hi,

  It depends on the table you are getting that prompt.  If it is a NON SAP table and  non critical DB table, i think you can ignore this pop up and proceed.

Please check whether connectivity between SAP & DB is running fine as well as  no error logs (SM21) & ABAP dumps are occuring in ST22.

If everything is going well, then you can ignore about that prompt.

Thanks and Regards,

Vimal

[former_member209962]

Hi Vimal,

Thanks for quick reply,  this is a JAVA system EP 7.2

And we got this error as pop up in middle of upgrade hence we ignored and moved.

Thanks

Tabrez

[Former Member]

Hi,

Did you performed any functional/technical testing with your upgrade system??

Did you face any issues?  If no, i think you can ignore that prompt.

Thanks and Regards,

Vimal