Oracle database structure
1, storage structure
Oracle's storage structure is divided into physical storage and logical storage.
1.1 Physical Storage
Composed of data files, record files, parameter files, control files.
1.2 logical storage
Composed of table space, table, data segment, zone, and data block.
1.3 Increase the three ways of the database size
A, new data file: ALTER TABLESPACE SYSTEM Add DataFile 'Data2.ora'
B, add table space: Create TableSpace users DataFile 'Data2.ora'
c, expand the size of the data file: ALTER DATABASE DATAFILE 'DATA2.ORA' AutoExtend On Next 20m MaxSize 1000M
