Display All Oracle Tables in the database. Shows all tables(less the system tables. Change for your databases. With where statement like "where owner in 'YOUROWNERNAME'"
set lines 200 set pages 200 select owner, table_name, table_type, tablespace_name from dba_all_tables where owner not in ('SYSTEM','DBSNMP','ORDSYS','OUTLN','SYS') order by owner, table_name, tablespace_name