DATABASE LOGICAL ARCHITECTURE

      In this case Oracle Database is seen as a collection of Tablespaces.
TABLESPACE:-
      It is logical storage area referring one or more Data files. Since Data files paths are lengthy as well as subjected to change Database to Database. It is difficult to remember and specified paths of Data files. As an alternative user friendly notation Tablespace concept is used to refer physical Data files while creating the tables.
      The initial Database is created with 5 or 6 Tablespaces corresponding 5 or 6 Data files.
        TABLESPACE      DATA FILE
         SYSTEM              system01.dbf
         SYSAUX               sysaux01.dbf
         UNDOTBS1         undotbs01.dbf
         USERS                 users01.dbf
         TEMP                  temp01.dbf
         EXAMPLE            example01.dbf
 
 
 
 
Obtaining details of Tablespaces:-

 
 
 
 
Obtaining details of Data files along with Tablespaces:-

 
 
 
 
Default Tablespace for normal users:-

 
 
 
 
 
Default storage for DBA users:-

 
 
 
 
 
Creating a Table on particular Tablespace:-

Here V$DATA FILE, V$CONTROLFILE, V$TEMPFILE, V$LOG, V$LOGFILE and V$TABLESPACE are the predefined views.