List all tables in your Oracle database

select owner, table_name from all_tables;
select * from all_tables;
more on ss64.com