What are Tablespaces
A tablespace is made from at least one datafile. Many datafiles can be within a tablespace. This is a logical grouping of datafiles.
A datafile cannot be split between tablespaces or shared and is exclusively used by a tablespace.
There are two types of tablespace permanent and temporary.
A permanent tablespace contains data pertinent to the database and is non-transitive, the data remains.
A temporary tablespace is transitive in nature. The data is volatile, and consists of space set aside for large data sorts and intermediate results in the query process.
No comments:
Post a Comment