The New Home of Oracle-wiki.net
All things oracle...
A website for IT Professionals involved with Oracle database.
--
-- List All Tables With Supporting Information
--
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
SET VERIFY OFF
select tab.owner as schema_name,
tab.table_name as table_name,
obj.created,
obj.last_ddl_time as last_modified,
tab.num_rows,
tab.last_analyzed,
comm.comments
from all_tables tab
inner join all_objects obj
on obj.owner = tab.owner
and obj.object_name = tab.table_name
left outer join all_tab_comments comm
on tab.table_name = comm.table_name
and tab.owner = comm.owner
where tab.owner not in ('SYS','SYSTEM')
order by tab.owner,
tab.table_name
/
Published on
Published 18th June 2025