Showing posts with label Tablespace Layout in R3. Show all posts
Showing posts with label Tablespace Layout in R3. Show all posts

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)