What is SYSTEM tablespace and When is it Created?

Answer Posted / nishi

Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

824


What are the components of logical database structure in oracle database?

812


Explain the use of indexes option in exp command.

760


How to use "out" parameter properly?

816


State the various uses of dbcc command?

747


What is tns name?

722


How to write an inner join with the where clause in oracle?

789


What is Trigger in Oracle?

773


Differentiate between translate and replace?

791


What are oracle functions?

757


What is a table in oracle?

704


Please explain compound trigger in oracle?

786


What is raw datatype?

815


Is oracle a relational database?

693


What are nested tables?

841