Types of Tablespaces
DBAs create tablespaces for the ease of control and maintenance over the information and structures within the Oracle database. There are two types of tablespaces in an Oracle database: SYSTEM and everything else.
The SYSTEM tablespace is created when you create the database. Its purpose is to hold the data dictionary tables, views, and stored program units. It also holds the SYSTEM undo segment. User data should never be stored in the SYSTEM tablespace although as yet, there is nothing to stop you from doing it.
The non-SYSTEM tablespaces are created by the DBA to enable more control and flexibility in database administration.
Non-SYSTEM tablespaces allow you to separate UNDO information, temporary information, application ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
