- 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';
- How to find out the default tablespace for a specific user in oracle ?
select default_tablespace from dba_users where username = 'SCOT';
- Query to find out all the available tablespace names in an Oracle db ?
select * from dba_tablespaces;
- Query to find out the default permanent and default temp tablespaces of a database ?
select * from database_properties where property_name like '%TABLESPACE%';
Like this:
Like Loading...