In SAP systems with the Oracle database, tablespaces and data files are named according to the conventions described in this section.
You might need to create a new tablespace, for example, in the following situations:
During the repository switch in a SAP system upgrade
When moving a table to a separate tablespace (for example, for administrative reasons)
For more information on extending a tablespace, see Extending a Tablespace with BR*Tools.
We strongly recommend you to create new tablespaces and add data files to extend existing ones in accordance with the SAP naming conventions (see Structure below).
There is a new convention for naming tablespaces. This is generally valid for new installations or new tablespaces as of SAP Web Application Server 6.10.
However, the new naming convention is also used if you have Multiple Components in One Database (MCOD) for SAP 4.6C and SAP 4.6D.
Tablespace Naming Convention as of SAP Web Application Server 6.10
The following table contains an overview of all the tablespaces in an SAP system and how they are used:
Tablespace Name |
Use |
---|---|
SYSTEM |
Oracle system tablespace |
SYSAUX |
Oracle auxiliary system tablespace |
PSAPTEMP |
Temporary obejcts (system default temporary tablespace) |
PSAPTEMP<n> |
Additional temporary objects, if required. Example: PSAPTEMP2. |
PSAPUNDO |
Undo tablespace (used from Oracle 9i instead of PSAPROLL) |
PSAP<SCHID> |
All objects of the SAP schema <SCHID>. Example: PSAPSRS. |
PSAP<SCHID><rel>[X] or PSAP<SCHID><rel>[X] |
Exchange tablespace for schema <SCHID> upgrade. Example: PSAPSRS720. |
PSAP<SCHID>USR |
Customer-specific objects for schema <SCHID>. Example: PSAPSRSUSR. |
PSAP<SCHID><name> |
Additional customer-specific objects for schema <SCHID>. Example: PSAPSRSDAT. |
The association of objects to PSAP<SCHID>, PSAP<SCHID>USR, or PSAP<SCHID><name> is controlled using the TABART in DD09L, TAORA, and IAORA. Exchange tablespaces have no TABART.
Tablespace Naming Convention Before SAP Web Application Server 6.10
The following syntax is used for naming tablespaces (TSP):
PSAP<name>D for data tablespaces
PSAP<name>I for index tablespaces
PSAP<TSP> if it is not important to differentiate
The following table contains an overview of all the tablespaces in an SAP system and how they are used:
Tablespace name |
Use |
---|---|
Oracle Tablespaces |
These tablespaces are required for operation of the Oracle DBMS, and contain no SAP data. |
SYSTEM |
Oracle system tablespace |
SYSAUX |
Oracle auxiliary system tablespace |
PSAPROLL |
Rollback segments |
PSAPTEMP |
Sort processes |
SAP NetWeaver tablespaces |
|
PSAPLOADD/I |
Screen and report loads (ABAP) |
PSAPSOURCED/I |
Screen and report sources (ABAP) |
PSAPDDICD/I |
ABAP Dictionary |
PSAPPROTD/I |
Log-like tables (such as spool) |
PSAPEL46D/I |
Exchange tablespace loads |
PSAPES46DD/I |
Exchange tablespace sources |
Application |
|
PSAPCLUD/I |
Cluster tables |
PSAPPOOLD/I |
Pooled tables (such as ATAB) |
PSAPSTABD/I |
Master data, transparent tables |
PSAPBTABD/I |
Transaction data, transparent tables |
PSAPDOCUD/I |
Doc., Sapscript, Sapfind |
Customers |
|
PSAPUSER1D/I |
Customer tables |
Data Files
When you add a new data file to extend a tablespace, BRSPACE attempts to add a new file to the standard SAP directory in which the most recent data file of the tablespace was stored. The most recent file is the one with the highest relative file number.
The naming conventions are as follows:
Directory: <SAPDATA_HOME>/sapdata<n>/<tablespace suffix>_<file number>
File: <tablespace suffix>.data<file number>
<tablespace suffix> is the second half of the tablespace name, for example, UNDO for the tablespace PSAPUNDO.
<n> is the sequentially assigned number of the SAP directory in which the data file will be stored.
<file number> is the sequentially assigned number of the data file in the tablespace. The same number also appears in the subdirectory that is created for each new file in a tablespace.
For example, the first data file for PSAPUNDO is called:
Directory: <SAPDATA_HOME>/sapdata<n>/undo_1
File: undo.data1
For more information on <SAPDATA_HOME>, see: