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.
