Friday, 6 March 2015

Oracle Database TableSpace

View where the tablespaces are located:

select file_name from dba_data_files where tablespace_name='USERS';

View the tablespace size of a tablespace:

select sum(bytes/1024/1024/1024),sum(maxbytes/1024/1024/1024) from dba_data_files where tablespace_name='USERS';

View if the tablespace is auto extendable:

select AUTOEXTENSIBLE from dba_data_files where tablespace_name='USERS';

Explain the Database Table for Tablespace:

desc dba_data_files

#bearMan