sql
select * from user_tables; select * from all_tables where owner='OTHER_TABLE' order by table_name asc;