SAPDBA Naming Convention

File Systems

As a default, SAPDBA 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 file number.

• Directory:
/sapdata/_

• File name:
.data

Also see Environment Variables.

is the sequentially assigned number of the SAP directory in which the data file will be stored.

is the sequentially assigned number of the data file in the tablespace. The same number also appears in the subdirectory which is created for each new file in a tablespace.

You are adding a third data file to tablespace PSAPDOCUD in the R/3 System database C11. PSAPDOCUD consists of the following files:

/oracle/C11/sapdata1/docud_1/docud.data1
/oracle/C11/sapdata2/docud_2/docud.data2

SAPDBA suggests /oracle/C11/sapdata2 for the new data file, and creates a subdirectory docud_3 , in which the file is created with name docud.data3 .

Thus, the complete new file name is:
/oracle/C11/sapdata2/docud_3/docud.data3 .