What is the tablespace in Oracle? Purpose and significanceA tablespace is a logical container unit within an Oracle database. It does not exist physically on a filesystem, however, it consists of at least one datafile which is physically located on the file system of the server. Every table, index etc in Oracle is logically stored in a tablespace. It acts as a bridge between Oracle database and the file system in which the data is physically stored.
There are 3 types of tablespaces in oracle:
- Permanent tablespace
- Undo tablespace
- Temporary tablespace