Friday, December 14, 2007

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)
  • PSAPELD/I - (Standard tablespace for release load programs)
  • PSAPESD/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)
  • PSAPDB (default tablespace for all SAP objects of the Java stack)
  • PSAPUSR (default tablespace for all customer objects)
  • PSAPREL (default tablespace for release-dependent data)
  • PSAP (Additional tablespace for example)

No comments:

Blog Archive