What is the functionality of SYSTEM table space

bhavana · 23-01-07, 03:00 PM

What is the functionality of SYSTEM table space <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

ajithcharles · 26-01-07, 08:58 PM

SYSTEM tablespace is purely used for DBA purposes.
The advantage of having a separate tablespace is the DBA can make the tablespace offline or readonly if he needs to perform any operations.

sriodba · 09-02-08, 03:08 AM

hi system tablespace is where all the data dictionary tables, views reside and system tablespace cannot be taken offline and if any user is not assigned any default tablespace then the default location to store data is system tablespace as the system tablespace keeps growing the performance of the DB degrads. so no users are assigned system tablespace.

mymailbox.21 · 13-03-08, 05:23 PM

system tablespace will store complete information about database in the form of base tables.

since base tables(i.e system tablespace) will be accessed all the time it is not recommended to grant quotas for normal users on this

23-01-07, 03:00 PM	#1 (permalink)
bhavana Senior Member Join Date: Jan 2007 Posts: 598 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 7	What is the functionality of SYSTEM table space What is the functionality of SYSTEM table space <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

26-01-07, 08:58 PM	#2 (permalink)
ajithcharles Senior Member Join Date: Mar 2006 Age: 24 Posts: 343 Thanks: 3 Thanked 12 Times in 12 Posts Thanks: 3 Thanked 12 Times in 12 Posts Rep Power: 8	Re: What is the functionality of SYSTEM table space SYSTEM tablespace is purely used for DBA purposes. The advantage of having a separate tablespace is the DBA can make the tablespace offline or readonly if he needs to perform any operations. __________________ JSP,Oracle,SQL : http://mycodesnippetjsp.blogspot.com/ Complete List :http://www.blogger.com/profile/04567238067268200918

09-02-08, 03:08 AM	#3 (permalink)
sriodba Junior Member Join Date: Feb 2008 Age: 28 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What is the functionality of SYSTEM table space hi system tablespace is where all the data dictionary tables, views reside and system tablespace cannot be taken offline and if any user is not assigned any default tablespace then the default location to store data is system tablespace as the system tablespace keeps growing the performance of the DB degrads. so no users are assigned system tablespace.

13-03-08, 05:23 PM	#4 (permalink)
mymailbox.21 Junior Member Join Date: Mar 2008 Age: 25 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What is the functionality of SYSTEM table space system tablespace will store complete information about database in the form of base tables. since base tables(i.e system tablespace) will be accessed all the time it is not recommended to grant quotas for normal users on this

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
THE PERIPHERAL NERVOUS SYSTEM	yathish	Health & Fitness	1	28-11-08 12:07 AM
Mega Free Download S/W Links A-Z	yathish	OTHERS	513	30-09-08 02:49 PM
some recent major computer system failures caused by software bugs	AjayKumar.Kataram	Latest Tech News & Innovations	2	21-12-06 05:06 PM
technical info on hard drives-2	abeetha.m	OTHERS	0	09-07-06 12:29 PM
regarding oracle versions	Madhuri	ORACLE , SQL SERVER , SYBASE & Others	7	07-07-06 07:06 PM