o To use the RMU Convert command for a database, you must have
the RMU$CONVERT or RMU$RESTORE privilege in the root file
access control list (ACL) for the database or the OpenVMS
SYSPRV or BYPASS privilege.
o The RMU Convert command requires read/write access to the
database root file, the RDB$SYSTEM area, and the directory in
which the .ruj file will be entered.
o Oracle Corporation recommends that you update multisegment
index cardinalities as part of, or soon after, the convert
operation completes.
Stored cardinality values can differ from the actual
cardinality values if the RDB$SYSTEM storage area has been
set to read-only access.
If you use the Confirm and Commit qualifiers when you issue
the RMU Convert command, Oracle RMU asks if you want to update
multisegment index cardinalities with actual index values
and provides an estimate on the time it will take to perform
the update. If you choose not to update these cardinalities
with actual values as part of the convert operation, or if
you do not use the Confirm qualifier, Oracle RMU updates
the multisegment index cardinalities with estimated values.
In such a case, you should update the cardinalities with
actual values as soon as possible by issuing an RMU Collect
Optimizer_Statistics command. See Collect_Optimizer_Statistics
for details.
o If the database conversion does not complete (for example,
because of a system failure or an Oracle Rdb monitor
shutdown), you can execute the RMU Convert command again
later. The ability to complete the conversion process later
keeps you from having a half-converted database that is
corrupted.
o If the RDB$SYSTEM storage area attribute is set to read-
only access, the RMU Convert command proceeds to reset the
attribute to read/write, convert the database and then reset
the attribute to read-only when the conversion is complete. If
the RDB$SYSTEM storage area is located on a device that cannot
be written to, the database conversion fails and returns an
error message.
o You are prompted to specify the Prefix_Collection parameters
if the following conditions are true:
o The Prefix_Collection qualifier is not specified.
o The RMU Convert process is not running as a batch job.
o The Noconfirm qualifier is not specified.
As a response to the prompt, you can enter "E(NABLE)" for
the equivalent of Prefix_Collection=Enabled, "F(ULL)" for
the equivalent of Prefix_Collection=Full, "D(ISABLE)" for the
equivalent of Prefix_Collection=Disabled, or the default of
"I(GNORE)" if you do not want to change any prefix cardinality
settings.