What Is A Tablespace

1.	What Is A Tablespace
Answer» Oracle use TABLESPACE for logical data STORAGE. Physically, data will get stored in Datafiles. Datafiles will be connected to tablespace. A tablespace can have multiple datafiles. A tablespace can have objects from different SCHEMA's and a schema can have multiple tablespace's. Database creates "SYSTEM tablespace" by DEFAULT during database CREATION. It contains read only data dictionary tables which contains the information about the database. Oracle use Tablespace for logical data Storage. Physically, data will get stored in Datafiles. Datafiles will be connected to tablespace. A tablespace can have multiple datafiles. A tablespace can have objects from different schema's and a schema can have multiple tablespace's. Database creates "SYSTEM tablespace" by default during database creation. It contains read only data dictionary tables which contains the information about the database.

Answer»

Oracle use TABLESPACE for logical data STORAGE. Physically, data will get stored in Datafiles. Datafiles will be connected to tablespace. A tablespace can have multiple datafiles. A tablespace can have objects from different SCHEMA's and a schema can have multiple tablespace's. Database creates "SYSTEM tablespace" by DEFAULT during database CREATION. It contains read only data dictionary tables which contains the information about the database.

Oracle use Tablespace for logical data Storage. Physically, data will get stored in Datafiles. Datafiles will be connected to tablespace. A tablespace can have multiple datafiles. A tablespace can have objects from different schema's and a schema can have multiple tablespace's. Database creates "SYSTEM tablespace" by default during database creation. It contains read only data dictionary tables which contains the information about the database.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Use A Pointer To A Function?
What Is Size Of Void Pointer?
Write A C Program To Find Size Of Structure Without Using Sizeof Operator?
What Is The Meaning Of Prototype Of A Function?
What Is Wild Pointer In C?
What Is Dangling Pointer In C?
Write A C Program To Swap Two Variables Without Using Third Variable ?
In C, What Is The Difference Between A Static Variable And Global Variable?
Is Using Exit() The Same As Using Return?
Why Does Pascal Matter? Is There Any Benefit To Using Pascal Functions?