VMS Help  —  RMU72  Verify  Command Qualifiers, Constraints
    Constraints
    Constraints[=(Constraints=(list))]
    Constraints[=(Tables=(list))]
    Constraints[=(Tables=(list), Constraints=(list))]
    Noconstraints

    Specifies which constraints Oracle RMU is to load and execute
    to check the integrity of data in the database. In addition,
    external routines (procedures and functions) referenced by
    constraints are activated and executed. Any exceptions produced
    cause the verify operation to report a failure. See the
    description of the routines qualifier for information on how
    routines are activated and executed.

    The options are as follows:

    o  Tables=(list)

       Specifies the table for which constraints are to be checked.
       If you specify more than one table, separate each table name
       with a comma and enclose the list in parentheses. You can
       specify the wildcard character, the asterisk (*),  instead of
       a table list to indicate that you want constraints checked
       for all tables in the database. This option is useful if you
       issued an RMU Load command with the Noconstraints qualifier.

    o  Constraints=(list)

       Specifies the constraints which you want Oracle RMU to load
       and execute. If you specify more than one constraint, separate
       each constraint name with a comma and enclose the list in
       parentheses. You can specify the wildcard character, the
       asterisk (*),  instead of a constraint list to indicate that
       you want all constraints checked for the database.

    o  (Tables=(list), Constraints=(list))

       You can specify both the Tables and Constraints options to
       specify which combination of tables and constraints you
       want Oracle RMU to verify. If you specify the wildcard
       character, the asterisk (*),  for the Tables option and a
       named constraint or constraints for the Constraint option
       within the same Oracle RMU command line, Oracle RMU verifies
       all constraints.

    See the Oracle Rdb Guide to Database Maintenance for more
    information on verifying constraints.

    See the Usage Notes entry in this command for the rules that
    determine which qualifiers can be used in combination on the same
    RMU Verify command line.

    The default is the Noconstraints qualifier. When you specify
    the Noconstraints qualifier, Oracle RMU does not verify any
    constraints.
Close Help