Oracle 10g: Show All Tables Command

...at times when we need to list out all the tables in our database..this command saves us a lot of time...

select owner, table_name, tablespace_name
from dba_tables
group by owner,table_name, tablespace_name