List all Tables in Oracle Database

By Santhosh N

Listing all tables in Oracle depends on the user logged in and the schema one logs in

TO list all the tables present in the Oracle Database,

1. If logged in as DBA, then one can see using the query

SELECT TABLE_NAME FROM DBA_TABLES WHERE owner = 'schema_name';

2. If logged in as a normal user without DBA access, then this can be used

SELECT TABLE_NAME FROM ALL_TABLES WHERE owner = 'schema_name';

3. If logged into single schema, then this can be used

SELECT TABLE_NAME FROM USER_TABLES;

List all Tables in Oracle Database  (3051 Views)