“ORA-00942: table or view is not existing.” is output on exception_XXXX-XX-XX_XX-XX-XX_xxxxxxxxxxxxx.log during using intra-mart products. This issue is not solved although I restart intra-mart. – NTT DATA INTRAMART CORPORATION

[Condition]
This issue is corresponding to the following according to the information from ORACLE Company in the case you are using Oracle for DB.

[Content]

This issue might correspond to Bug of following ORACLE products.

　=====================================================

　Bug 9577583
　False ORA-942 or other errors when multiple schemas
　have identical object names (Document ID 9577583.8)

　=====================================================

[Occurrence Condition]
･Using ORACLE 11.2.0.1 version.
･In the case that same name object exists in the another schema.
･In the case that SQL which is executed is not doing schema modification.

[Description]
System accesses the same name object in the other schema which is not intended and as a result, ORA-00942 or other unexpected error occur.

ORA-00942 occurs because system cannot refer to the information that the same object in the other schema is in the library caches correctly.

[Handling method]
･Apply individual patch of ORACLE 11.2.0.1.0 of Bug 9577583
･Upgrade to fixed version (ORACLE 11.2.0.2.0. or later)
-- Target ------------------------------------------------------------------------
iAP/Accel Platform/All Updates
-------------------------------------------------------------------------------

FAQID:502