Oracle tablespace concept and increasing size of Oracle tablespace

Oracle Tablespace Concept

In Oracle world you will frequently hear about the word “tablespace”. So what is a table Tablespace?

To put very simply it is the Logical area of Oracle where all your data goes. The Tablespace holds your data for your tables and indexes. It other words the tablespace is a container where your data is kept. A tablespace is a logical concept only, it has no physical existence.

A tablespace is comprised of one or more datafiles. The files are the real operating system files that physically exist in your computer’s disks. Continue reading