Naming Conventions for Files (Windows NT) 

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.

Programs like the File Manager or SVRMGR can keep files open, which can result in significant problems when SAPDBA attempts to access these files. You should therefore shut down these programs before calling SAPDBA.