What is SYSTEM tablespace and when is it Created?

Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

Interview Candidate
Sep 5th, 2004
3
1814

Concepts and Architecture

Answer

Showing Answers 1 - 3 of 3 Answers

Praveen

Sep 14th, 2006

Hello
As far as i know, a system tablespace is the only tablespace which is created automatically, when the oracle DB is installed, no matter what the DB will contain atleast one tablespace and that is the system tablespace. Do let me know if u have any other answers.
Praveen.R

Mohammed Abdul Afroze

Sep 20th, 2007

Every Oracle Database contains a tablespace called system tablespace.This tablespace gets created at the time of database creation and it holds data dictionary information for the entire database.