VMS Help  —  RMU72  Move Area, Usage Notes
    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).
Close Help