System and Non-System Tablespace In Oracle

CC9MQ3DSYSQQ

SYSTEM Tablespace

• Created with the database 
• Required in all databases
• Contains the data dictionary, including stored program units
• Contains the SYSTEM undo segment
• Should not contain user data, although it is allowed

Non-SYSTEM Tablespaces

• Enable more flexibility in database administration 
• Separate undo, temporary, application data, and application index segments
• Separate data by backup requirements
• Separate dynamic and static data 
• Control the amount of space allocated to user’s objects

People who read this post also read :

Posted in: Tablespace