Tablespace Usage
Reserve the SYSTEM tablespace for data dictionary
objects
Create locally managed tablespaces to avoid space
management issues
Split tables and indexes into separate tablespaces
Create separate rollback tablespaces
Store very large database objects in their own
tablespace
Create one or more temporary tablespaces