Tablespace

[nkumarin001]

Hi,

What is the use ot tablespace as it is logical structure and will not consume any space so why do we need it?
What happens when we give create tablespace command?

Regards,
Naveen

[Medhatithi]

The create tablespace command creates a tablespace and also the datafiles that are to be used by the objects in that tablespace. Remember, that one tablespace can span across several datafiles. Tablespace is a logical construct unlike the datafile, which is a physical one. There are several other logical constructs like blocks, extents, segments. These are very useful for optimised database performance. For example, when you create a database, you need to specify the database block size. Again, that is a logical construct. But, such grouping by blocks enables database activities to be performed properly and efficiently.

[nkumarin001]

The create tablespace command creates a tablespace and also the datafiles that are to be used by the objects in that tablespace. Remember, that one tablespace can span across several datafiles. Tablespace is a logical construct unlike the datafile, which is a physical one. There are several other logical constructs like blocks, extents, segments. These are very useful for optimised database performance. For example, when you create a database, you need to specify the database block size. Again, that is a logical construct. But, such grouping by blocks enables database activities to be performed properly and efficiently.

Hi Medhatithi,

Thank you for answering it helped me a lot.

Regards,
Naveen