I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.

drudd

So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query:

SELECT DISTINCT
TABLE_NAME
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'ase_app_role_role_mbr'

However when I try to query the table

SELECT

*

FROM ase_app_role_role_mbr

I get an error:

ORA-00942: table or view does not exist

This is my first time seeing something like this and I would appreciate any advice on how to query the table.

SteveF-Oracle

Hi Drudd,

This community is for Oracle Analytics product questions, it appears you have a general database question that may be better answered in another forum.

In brief, when you query a table or view, depending upon which user you are logged into the Oracle database with, you may need to prepend the schema name, if you do not have explicit access to the table/view granted to your user/role.

If that does not answer your question, please post in a database forum.