Oracle Database Architecture Question:
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.
The SYSTEM tablespace is created automatically for each new Oracle database. It contains all the data dictionary objects for the entire database.
| Previous Question | Next 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? |