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

How to execute a stored procedure in oracle?

620


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

860


How to drop a stored procedure in oracle?

592


How index is implemented in oracle database?

597


What is data file?

619






How many memory layers are in the oracle shared pool?

643


How to end the current transaction in oracle?

561


How to rename a tablespace in oracle?

620


What are the differences between number and binary_float in oracle?

571


Explain the use of constraints option in exp command.

566


What is the max number of columns in an oracle table?

516


How to declare a local variable?

596


What is execute immediate in oracle?

549


what is the difference between functional dependecy and multilevel dependency?

1994


What is archive log in Oracle?

603