What Is A System Tablespace And When It Is Created?

1.	What Is A System Tablespace And When It Is Created?
Answer» When the database is CREATED in ORACLE database SYSTEM, it automatically generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains DATA dictionary tables for the ENTIRE database. When the database is created in Oracle database system, it automatically generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains data dictionary tables for the entire database.

Answer»

When the database is CREATED in ORACLE database SYSTEM, it automatically generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains DATA dictionary tables for the ENTIRE database.

When the database is created in Oracle database system, it automatically generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains data dictionary tables for the entire database.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Components Of Physical Database Structure Of Oracle Database?
What Is Hot Backup And How It Can Be Taken?
What Is Hash Cluster?
What Is The Use Of Aggregate Functions In Oracle?
Explain The Function Of Optimizer In Oracle?
What Is An Oracle Index?
What Is The Purpose Of Save Points In Oracle Database?
What Is Using Clause And Give Example?
What Is The Fastest Query Method To Fetch Data From The Table?
What Is A System Tablespace And When It Is Created?

What Is A System Tablespace And When It Is Created?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment