You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Table "ALL_TABLES" - does not include all tables?

Accepted answer
39
Views
4
Comments
edited Mar 11, 2020 11:23AM in Reporting and Analytics for ERP 4 comments

Content

Hi,

When I run a query in BI Publisher Enterprise, I can for example, get results from this query:

SELECT DISTINCT UPPER(table_name), num_rows
FROM all_tables
WHERE num_rows > 0
AND UPPER(table_name) like 'PJC%'
ORDER BY num_rows DESC

However, some tables are not in ALL_TABLES yet I can still run searches against them - e.g.

  • FND_GRANTS
  • FND_OBJECTS_VL
  • ASE_ROLE_B
  • ASE_ROLE_ROLE_MBR

If I can't search for those tables in ALL_TABLES, how can I know they are there, other than e.g. checking Oracle Docs - examples:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!