Composition of the database structure

1. Physical Storage structure:

Definition: A real data storage unit

Composition

(1) Data files: Data files that store databases

(2) Log file: Record the modification information to the data

(3) Control file: a binary file that records the physical structure of a database (including data files and log files)

Therefore, when the Oracle instance starts, it must access the control file

2. Logical Structure

Definition: The relationship between the logical concepts formed after database creation

Tablespace (logical Component Tablespase): A logical unit of data stored in an Oracle database

Classification:

(1) System tablespace: data for storing internal tables and data dictionaries in Oracle Systems

(2) Sysaux table space: Objects used to store common sample users inside Oracle

(3) Undo tablespace: Table space to hold revocation information

(4) Users table space: The table space that Oracle recommends users use

(5) Temp tablespace: Special table space for temporary data

Composition of the database structure