The regular SAP naming conventions apply - that is, the data files are in directory
<drive>\oracle\<SID>\sapdata<n>\<tablespace name>_<file number> .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.