Question:
What is 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. Source: CoolInterview.com
The SYSTEM tablespace is created automatically for each new Oracle database. It contains all the data dictionary objects for the entire database.
Source: CoolInterview.com
Answered by: Altaf Hussain Banday | Date: 12/22/2009
| Contact Altaf Hussain Banday
system tablespace consists of triggers,procedures,functions and all other informations.it is created when the database is created Source: CoolInterview.com
Answered by: suriya k r | Date: 1/9/2010
| Contact suriya k r
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|