What is the functionality of SYSTEM table space ?
Answers were Sorted based on User's Feedback
Answer / ankur aggarwal
system tablespace is a main part of oracle database.All the
database information is in it.it is created when database
is created.
its managed by oracle server.dba cannot change its
containts.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / yogesh
1. Every Oracle Database Contain table space name System
which Oracle Create automatically When the Database is Created.
2. System Table space is always Open When Database is online.
3. You can Create Locally managed System table spaces.
4. System Table space is always Contained the
Data-dictionary table for the entire database.
5.It can not made Writable.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vivek
it contains the data dictionary objects which cannot be
modified by dba with few exceptions like aud$
Is This Answer Correct ? | 1 Yes | 0 No |
When Does DBWR write to the database?
• What is oracle Architecture?
How will you force database to use particular rollback segment?
What is the maximum size of a oracle9i database?
What is Dedicated Server Configuration?
What is the function of checkpoint(CKPT)?
How can we plan storage for very large tables ?
What is the significance of having storage clause ?
Can a Tablespace hold objects from different Schemes in Oracle?
How the log writer writes the data into database
what is ORACLE MEMORY STRUCTURES
What is a Control file ?