What is SYSTEM tablespace and When is it Created?

Answer Posted / chaudhry

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.

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Query to retrieve record for a many to many relationship ?

2080


What is oracle in java?

524


What is the dynamic sql in oracle?

598


How do I limit the number of rows returned by an oracle query after ordering?

636


11. Display the client number and name and the client number and name of the person who referred that client.

1920






Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1810


How to convert dates to characters in oracle?

584


What is the difference between view and materialized view in Oracle?

609


How to create a new view in oracle?

622


What is a system tablespace?

600


Explain the function of optimizer in oracle?

596


Can objects of the same schema reside in different tablespace?

590


How many anonymous blocks can be defined?

586


What is a trigger and what are its types in oracle?

534


How to view the tablespaces in the current database?

560