Ora - 942 Error

[Former Member]

Hi All,

I have installed PI 7.1 on Solaris with Oracle 10.2.0.4. When i execute transactions frequently i am receiving the below error:

Error occured during creation of oracle snapshot (Creation aborted)

(Log see also transaction SLG1, Object ORASNAP, Subobject ORASNAPCR)

Oracle snapshot creation program aborted

Error while copying from oracle view to SAP table

Oracle view SAP$KCBFWAIT

SAP table ORA_SAPKCBFWAIT

Return code (ORA-....) 942

You tried to work with the name of a table or view that does not exist in the database

The table does not exist in the database. It was processed with the name of a table or a view that does not exist in the database.

Could you please suggest me how to overcome this.

Thanks,

Subbu

[Former Member · Accepted solution]

I was having this a couple of times, have a look at sap note [159510 - DBIF_DSQL2_OBJ_UNKNOWN: Table does not exist|https://service.sap.com/sap/support/notes/159510]

  create or replace view sap_$kcbfwait as select * from x$kcbfwait;
  drop public synonym sap$kcbfwait;
  create public synonym sap$kcbfwait for sap_$kcbfwait;
  grant select on sap$kcbfwait to public;

Regards, Michael

[Former Member · Accepted solution]

HI Michael,

Thank you very much, i have applied the NOTE mentioned by you.

I didnt receive any error till now, will monitor for some more time.

Thanks,

Subbu

[Former Member]

Hello,

In SE14 transaction enter the object ORA_SAPKCBFWAIT, select table option and click on edit. If this object does exit the create database table option should be grayed out else create the table by clicking the same option. Hopefully this should resolve the problem.

Regards

Anil Verma B