madhavi

• Jun 3rd, 2005

 

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

Jacob

• Jul 9th, 2005

 

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

RAVI SALUJA

• Jan 10th, 2007

 

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

Thanks

Abood

• Apr 6th, 2007

 

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.

imran44

 Profile Answers by imran44 

• Jan 9th, 2009

 

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.

ayub

• Sep 18th, 2017

 

System tablespace is memory allocated by oracle and will be created at the time of database creation, stores information of data dictionary tables in database, with out system tablespace you can not open the database.