select OWNER, TABLE_NAME
from all_tables
where owner = user
order by 2;  

