The classic tablespace layout
The classic tablespace layout contains the following tablespaces:
- SYSTEM - (Oracle Dictionary)
- PSAPTEMP - (Standard tablespace for sort operations)
- PSAPROLL - (Standard tablespace for rollback segments)
- PSAPBTABD/I - (Standard tablespace for frequently changed data)
- PSAPSTABD/I - (Standard tablespace for rarely changed data)
- PSAPPOOLD/I - (Standard tablespace for SAP pool tables)
- PSAPPROTD/I - (Standard tablespace for log information)
- PSAPLOADD/I - (Standard tablespace for SAP loads (executables))
- PSAPSOURCED/I - (Standard tablespace for SAP sources (ABAP))
- PSAPDOCUD/I - (Standard tablespace for documentation tables)
- PSAPCLUD/I - (Standard tablespace for SAP cluster data)
- PSAPDDICD/I - (Standard tablespace for the SAP data dictionary)
- PSAPUSER1D/I - (Standard tablespace for data customers)
- PSAPEL
D/I - (Standard tablespace for release load programs) - PSAPES
D/I - (Standard tablespace for release source programs)
The new tablespace layout
The new tablespace layout contains the following tablespaces:
- SYSTEM (tablespace for the Oracle dictionary)
- SYSAUX (additional tablespace as of Oracle database 10g)
- PSAPTEMP (default tablespace for database sort operations)
- PSAPUNDO/PSAPROLL (default tablespace for segment undo/rollback)
- PSAP
(default tablespace for all SAP objects of the ABAP stack) - PSAP
DB (default tablespace for all SAP objects of the Java stack) - PSAP
USR (default tablespace for all customer objects) - PSAP
REL (default tablespace for release-dependent data) - PSAP
(Additional tablespace for example)
No comments:
Post a Comment