Query below lists:

(A) number of all tables accessible to the current user in Oracle database

(B) number of all tables in Oracle database

Query was executed under the Oracle9i Database version.

Query

A. Tables accessible to the current user

select count(*) as table_count
from sys.all_tables;

B. If you have privilege on dba_tables

select count(*) as table_count
from sys.dba_tables;

Columns

• table_count - number of tables in database

Rows

Query returns one row

Sample results