My Oracle Support Banner

Getting Table Doesn't Exist Error Even Though It's in the READ_ONLY_TABLES (Doc ID 2755302.1)

Last updated on MAY 31, 2024

Applies to:

Oracle Network Management for Utilities - DMS - Version 2.5.0.0.0 and later
Oracle Utilities Network Management System - Version 2.5.0.0.0 and later
Information in this document applies to any platform.

Goal

Adding a project specific view to read_only_tables, upon login, Getting table doesn't exist error in the weblogic sever log:

2021-02-17 12:24:49,870 WARN session.Session: nms-security or SQL problem: user:nms1 sql: select h_cls, h_idx, cust_txcompnum, p_cls, p_idx, alias from table_view_name where rownum <= 100
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

A dialog box with an ORA- "table or view does not exist" error appears.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.