Oracle Database Structure

Tablespace and Data Files

• The Table space is a logical space which have at least one data file which is a physical file.
• One data file is attached to one and only one table space;
• Table are in a table space;

Table Space List

Connect as sysdba with sqlplus and Select * from v$TABLESPACE

SQL> connect sys/password as sysdba
Connected.

SQL> select * from V$TABLESPACE;

       TS# NAME 			  INC BIG FLA ENC     CON_ID
---------- ------------------------------ --- --- --- --- ----------
	 1 SYSAUX			  YES NO  YES		   0
	 0 SYSTEM			  YES NO  YES		   0
	 2 UNDOTBS1			  YES NO  YES		   0
	 4 USERS			  YES NO  YES		   0
	 3 TEMP 			  NO  NO  YES		   0

SQL>

=Data File

SELECT FILE#, TS#, NAME, STATUS, ENABLED, BYTES FROM V$DATAFILE;