The interactions in this eCourse require Javascript to be enabled.
Managing Tablespaces
previous|next
Oracle Database XE comprises the following physical database structures:
Control file: Contains entries that specify the physical structure of the database
Data files: Contain all the database data. The content of logical database structures, such as tables and indexes, is physically stored in the data files.
Redo log files: Record all changes made to data
A database is divided into logical storage units called tablespaces that can be used to group related logical structures together. Each database is logically divided into one or more tablespaces. One or more data files are explicitly created for each tablespace to physically store the data of all logical structures in a tablespace.
You have seen how to store and display data in tables. These tables are created in tablespaces. Tablespaces and all the objects they contain are logical objects.
Logical data structures are stored in the physical files of the database,