Database Administration (MOSC)

MOSC Banner

The application could not see the table: Reports ORA-00942.

edited Apr 7, 2010 5:42PM in Database Administration (MOSC) 2 commentsAnswered
A third party application using Uniface.
This is the first time the problem has occurred, but this is not the first time the application has been used.
The table is used to verify the application can get to oracle and it failed on each attempt.  A public synonym
is on  the table.  The application had been using both table and synonym without any problems before this
occurred.

Table dropped out of sight for the application.  We were able to:
1. Desc table and see the table using sqlplus
2. Select data from the table using sqlplus
3. Verify necessary grants were there
4. Select from dba objects showing table and public synonym valid.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center