Interested to Buy Any Domain ? << Click Here >> for more details...
What is the functionality of SYSTEM table space ?
- 3 Answers
- 7627 Views
- I also Faced
- E-Mail Answers
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 |
what is the role of archiever
What is an Oracle Data Segment?
What does LGWR do?
What is the use of Oracle Control File?
How to find the current session sid
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is a Rollback segment entry ?
How to implement the multiple control files for an existing database ?
What are Oracle Schema Objects?
What is the maximum size of a oracle9i database?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What is an Oracle SYSTEM tablespace and when is it Created?
Oracle General 
