Some frequently used Oracle Queries.

1. How to find out the table space for a particular table in oracle ?

select tablespace_name from all_tables where owner = 'SCOT' and table_name like 'CUST';

2. How to find out the default tablespace for a specific user in oracle ?

select default_tablespace from dba_users where username = 'SCOT';

3. Query to find out all the available tablespace names in an Oracle db ?

select * from dba_tablespaces;

4. Query to find out the default permanent and default temp tablespaces of a database ?

select * from database_properties where property_name like '%TABLESPACE%';