Answer Detail: RE: What is SYSTEM tablespace and when is it created

GeekInterview.com > Interview Questions > Oracle > Database Administration

Print |

Question: What is SYSTEM tablespace and when is it created

April 04, 2007 06:41:25	#4
Abood	Member Since: Visitor Total Comments: N/A
RE: What is SYSTEM tablespace and when is it created
System tablespace is a tablespace that stores all the data dictionary tables in database and it is created at the time of database creation. This tablespace is always and must be online for database to be open.