Tablespace purposes and significances - oracle

What is the tablespace in Oracle? Purpose and significance

A 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
Sequence and sequence cache - oracle
Sequence and sequence cache - Seqences are often used to generate autonumber fields. A sequence is an object in Oracle used to create a number sequence...
Difference between formula column and place holder - oracle
Formula column and place holder - Difference between formula column and place holder...
How to create placeholder columns in oracle? - oracle
Placeholder columns in oracle - Steps to create placeholder columns: Click inside the container group at the position where you want the column to be placed...
Post your comment

Related Content

Follow us

▲