The application could not see the table: Reports ORA-00942.
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.
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.
0