Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
22
Views
4
Comments

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.

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.