Entering content frameBackground documentation Naming Conventions for Files (Windows NT) Locate the document in its SAP Library structure

The regular SAP naming conventions apply - that is, the data files are in directory <drive>\oracle\<SID>\sapdata<n>\<tablespace name>_<file number> .
Therefore, the first file of tablespace PSAPPOOLD could be called:
F:\oracle\C11\sapdata2\poold_1\poold.data1 .

You can store the files of one tablespace on different disks. SAPDBA requires that only the name of the drive be changed, and the remainder of the path ( \oracle\C11 in our example) remain the same, to avoid confusion with other databases.

SAPDBA also requires that the logical directory sapdata<n> is specified. A further subdirectory <tablespace name>_<file number> is created automatically.

For reasons of clarity, SAP recommends that you not spread a data pool (indicated by the subdirectory sapdata<n> ) among different disks.

For security reasons, SAPDBA never creates a subdirectory sapdata<n> itself; it only uses an existing one created in the File Manager or using the DOS box.

 

 

Leaving content frame