select * from all_tables;

select * from all_tab_columns;

Tom Best