Tablespace Usage
1 Reserve the SYSTEM tablespace for data dictionary objects.
2 Create locally managed tablespaces to avoid space management issues.
3 Split tables and indexes into separate tablespaces.
4 Create separate rollback tablespaces.
5 Store very large database objects in their own tablespace.
6 Create one or more temporary tablespaces.
Guidelines
1 Each database should have separate tablespaces specified for:
1.1 Data dictionary objects
1.2 Rollback segments and undo segments
1.3 Temporary segments
1.4 Tables
1.5 Indexes
1.6 Very large objects
2 Most production databases have many more tablespaces than this, but the important principle is to separate data of different types and with different uses for housekeeping and backup purposes.
3 The SYSTEM tablespace contains only data dictionary objects owned by sys. No other users should have the ability to create objects in it.
4 Remember that stored objects such as packages and database triggers form part of the data dictionary.
5 Rollback segments should use rollback segment tablespaces exclusively.
6 Undo segments can only exist in UNDO tablespaces thus making them exclusive.
请见
Tablespace Usage第四点
Guidelines1.2和5、6三处。
