Oracle Database Architecture Question:
Download Questions PDF

What is an Oracle SYSTEM tablespace and when is it Created?

Answer:

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.

The SYSTEM tablespace is created automatically for each new Oracle database. It contains all the data dictionary objects for the entire database.

Download Database Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
What is an Oracle Data Dictionary?Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?