System and Non-System Tablespace In Oracle

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 :


Post a Comment


Twitter Delicious Facebook Digg Stumbleupon Favorites More