Listing tables in DB

User tables
select distinct owner from dba_objects;

If you logged in as Normal User without DBA permission you may uses the following command to see your own schema’s all tables and views.

select * from tab;

it will show all tables in your schema cat synonym of user_catalog
select * from cat;

Leave a Reply