oracle table list

select * from dba_objects where object_type = 'TABLE';

select * from all_objects where object_type = 'TABLE';