Database Administration - What is SYSTEM tablespace and when is it created

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 4 of 225

What is SYSTEM tablespace and when is it created

Total Answers and Comments: 4

Last Update: April 06, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: RAVI SALUJA

A system tablespace is a memory allocated by oracle to creation of objects and is automatically created at the time of database creation

Thanks

Above answer was rated as good by the following members:
chiragblitz

June 03, 2005 06:28:19

madhavi

RE: What is SYSTEM tablespace and when is it created

System tablespace is the memory allocated by oracle for creation of objects,views,indexes.

this is created automatically by oracle when the Database is created

Is this answer useful? Yes | No

July 09, 2005 07:56:57

Jacob

RE: What is SYSTEM tablespace and when is it created

SYSTEM TABLESPACE USAGE NOTES:

Username - Name of the user
Created - User creation date
Profile - Name of resource profile assigned to the user
Default Tablespace - Default tablespace for data objects
Temporary Tablespace - Default tablespace for temporary objects

Only SYS, SYSTEM and possibly DBSNMP should have their default tablespace set to SYSTEM.

select USERNAME,
CREATED,
PROFILE,
DEFAULT_TABLESPACE,
TEMPORARY_TABLESPACE
from dba_users
order by USERNAME

Objects in SYSTEM TS
OBJECTS IN SYSTEM TABLESPACE NOTES:

Owner - Owner of the object
Object Name - Name of object
Object Type - Type of object
Tablespace - Tablespace name
Size - Size (bytes) of object

Any user (other than SYS, SYSTEM) should have their objects moved out of the SYSTEM tablespace

select OWNER,
SEGMENT_NAME,
SEGMENT_TYPE,
TABLESPACE_NAME,
BYTES
from dba_segments
where TABLESPACE_NAME = 'SYSTEM'
and OWNER not in ('SYS','SYSTEM')
order by OWNER, SEGMENT_NAME

Is this answer useful? Yes | No

January 10, 2007 12:26:00

RAVI SALUJA

RE: What is SYSTEM tablespace and when is it created

A system tablespace is a memory allocated by oracle to creation of objects and is automatically created at the time of database creation

Thanks

Is this answer useful? Yes | No

1 0

Overall Rating: +1

April 06, 2007 06:41:25

Abood

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.

Is this answer useful? Yes | No

Go To Top