Pr.Pg Next Pg

Oracle Database Structure

  • Oracle’s database structures include, tablespaces, control files, redo log files, archived logs, block change tracking files, Flashback logs, and recovery backup (RMAN) files.

 

 

Tablespaces

  • All of the data stored within an Oracle database must reside in a tablespace.

  • Each tablespace is composed of physical structures called datafiles.

  • Each tablespace consist minimum one to many datafiles, and each datafile can belong to only one tablespace.

  • When creating a table, you can specify the tablespace in which to create it.

  • Oracle will then find space for it in one of the datafiles that make up the tablespace.

  • Oracle Database can be deployed on up to 64,000 datafiles.

 


Pr.Pg Next Pg