Other Data Layout Issues
To conclude the data layout discussion we examine symlinks, RAID performance with databases, and some of the pros and cons of Veritas and Solaris Volume Manager.
Database File Naming Using Symlinks
Whether raw devices or file system files are used for database files, it can prove inconvenient to move a file to a different location since file names are hardcoded at the time tablespaces are created. A simple and elegant solution to this problem is to create tablespaces using symlinks rather than direct file names.
For example, suppose the customer table consists of three database files placed on Veritas raw volumes: /dev/vx/rdsk/ourdata/vol23a, /dev/vx/rdsk/ourdata/vol34, and /dev/vx/rdsk/ourdata/vol16. Rather than hardcode ...