Creation of tablespace in oracle database

[Garlands]

Need to some guidance related to creation of tablespace in oracle database.I am learning somewhere and need to step forward for further. They are not on this topic currently but I need to learn something from Internet and find this interesting site.Would you please elaborate " Creation of Tablespace" topic in detail.Thanks....

[Reegan]

The Tablespace :

A database is dispersed into one or more logical storage unit called tablespaces and the tablespaces are further divided into segments and the segments are also divided into extents.

The segment is set extents which occupied all the data and contents for a particular logical storage structure.when you create any segment,it is taken by extents and specified allocated extent will receive the creation of segment and if segment is increasing continuously and reached to the maximum of extent size then another extent would be allocated to that segment.

[MindSpace]

Types of tablespaces :

The oracle database uses different types of tablespaces for different purpose,I am going to describe here some details about the types of tablespaces :

1- SYSTEMIt always stay online till database would open and contains the data dictionary and stored procedure.
2 -UNDO It contains the undo data after any updation of database objects.
3- TEMPORARY The temporary tablespace contains the temporary segemnts of database.i.e. After sorting operation the data is being sorted in this area and then displayed to the users.

You can use these tablespaces in your database to use for different storage mechanism and the tablespaces which is created by user is called regular tablespace.

[Modifier]

Creating tablespace:

You can create a tablespace to store the different types of database objects and you need to use this statement to create a tablespace :

SQL> Create tablespace <tablespace name> datafile '<path of the data file name>
' size <space in MB>;

This is simple procedure to create a tablespace ,It has so many options according to your use .