o To use the RMU Move_Area command for a database, you must have the RMU$MOVE privilege in the root file access control list (ACL) for the database or have the OpenVMS SYSPRV or BYPASS privilege. o You cannot disable extensions of snapshot (.snp) files. o The parameter (file and area) qualifiers for the RMU Move_Area command have positional semantics. See the Command_Qualifiers help entry for more information on parameter qualifiers. o The RMU Move_Area command provides four qualifiers, Directory, Root, File, and Snapshots, that allow you to specify the target for the moved files. The target can be just a directory, just a file name, or a directory and file name. If you use all or some of these four qualifiers, apply them as follows: - If you want to move the database root, use the Root qualifier to indicate the target for the moved database root file. - Use local application of the File qualifier to specify the target for the moved storage area or areas. - Use local application of the Snapshots qualifier to specify the target for the moved snapshot file or files. - Use the Directory qualifier to specify a default target directory. The default target directory is the directory to which all storage area and snapshot files not qualified with the File or Snapshot qualifier are moved. It is also the default directory for files qualified with the Root, File, or Snapshot qualifier if the target for these qualifiers does not include a directory specification. Note the following when using these qualifiers: - Global application of the File qualifier when the target specification includes a file name causes Oracle RMU to move all of the specified storage areas to different versions of the same file name. This creates a database that is difficult to manage. - Global application of the Snapshot qualifier when the target specification includes a file name causes Oracle RMU to move all of the specified snapshot files to different versions of the same file name. This creates a database that is difficult to manage. - Specifying a file name or extension with the Directory qualifier is permitted, but causes Oracle RMU to move all of the specified files (except those specified with the File or Root qualifier) to different versions of the same file name. Again, this creates a database that is difficult to manage. See Example 6. o You must specify the Root qualifier when you use the RMU Move_ Area command on a single-file database. If you omit the Root qualifier, you receive an error message. If you want to place the snapshot file for a single-file database on a different device or directory from the root file, Oracle Corporation recommends that you create a multifile database. However, you can work around this restriction by defining a search list for a concealed logical name. (However, do not use a nonconcealed rooted logical name to define database files; a database created with a non-concealed rooted logical name can be backed up, but may not restore correctly when you attempt to restore the files to a new directory.) To create a single-file database with a snapshot file on a different device or directory from the root file, define a search list by using a concealed logical name. Specify the location of the root file as the first item in the search list. When you create the database, use the logical name for the directory specification. Then, copy the snapshot file to the second device. The following example demonstrates the workaround: $ ! Define a concealed logical name. $ DEFINE /TRANS=CONCEALED/SYSTEM TESTDB USER$DISK1:[DATABASE], - _$ USER$DISK2:[SNAPSHOT] $ $ SQL SQL> ! Create the database. SQL> ! SQL> CREATE DATABASE FILENAME TESTDB:TEST; SQL> EXIT $ ! $ ! Copy the snapshot file to the second disk. $ COPY USER$DISK1:[DATABASE]TEST.SNP USER$DISK2:[SNAPSHOT]TEST.SNP $ ! $ ! Delete the snapshot file from the original disk. $ DELETE USER$DISK1:[DATABASE]TEST.SNP; o There are no restrictions on the use of the Nospams qualifier option with mixed page format storage areas, but the use of the Nospams qualifier typically causes severe performance degradation. The Nospams qualifier is useful only where updates are rare and batched, and access is primarily by database key (dbkey).