CODEWITHSUNDEEP
oracle-databasec++11oracle11godbc
Igor
Igor

Reputation: 6255

Identify system table in Oracle 11

ALL,

Is there a way to identify the system tables in Oracle 11g?

If I call SQLTables() API, I will get a list of all tables available. What I'd like is to identify what table is internal Oracle and which one is user-made.

I'm connecting with the system account. (a dba one).

TIA!

Upvotes: 0

Views: 144

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

Query e.g. DBA_TABLES (which means that you have access to all tables in that database), using the OWNER column name as filter. For example:

select owner, table_name
from dba_tables
where owner in ('SYS', 'SYSTEM');

For more owners, query DBA_USERS:

select * from dba_users;

and include any you want into the first query.

Upvotes: 1

Related Questions