--

-- 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

/