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 231

What is SYSTEM tablespace and when is it created

Total Answers and Comments: 5

Last Update: January 09, 2009

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

January 09, 2009 08:19:16

imran44

Member Since: December 2008 Contribution: 12

RE: What is SYSTEM tablespace and when is it created

IN 10g there are two system table spaces called system and sysaux(auxillary) tablespace. These system tablespaces are backbone of database and data base will not function at all without these tablespaces. They created at the time of creation and contained meta data of the database. The meta data is the data about data. The system tablespace also contain data dictionary.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank