What is a Tablespace?
Tablespace in Oracle Database are logical storage units to store all the data. Logical storage units help users locate specific data and help in the retrieval of data.
Types of Tablespaces
- SYSTEM Tablespace – Oracle Database contains SYSTEM tablespace which is automatically created when the database is created. The tablespace contains a data file that stores data dictionary tables for the entire DB.
- Undo Tablespaces – These tablespaces store the undo information and nothing else.
Working on Oracle Tablespaces for Developers
A database, as defined by Oracle, is an organized collection of information typically stored electronically in a computer system. The explanation is simple, however, it’s not that simple to store the data.
The Database has a tablespace that stores all the data. Everything inside a database is stored in tablespace.