VMS Help  —  RMU72  Unload  After Journal, Command Qualifiers, Table
    Table=(Name=table-name, table-options)

    Specifies the name of a table to be unloaded and an output
    destination. The table-name must be a table within the database.
    Views, indexes, and system relations may not be unloaded from the
    after-image journal file.

    The asterisk (*)  and the percent sign (%) wildcard characters
    can be used in the table name specification to select all tables
    that satisfy the components you specify. The asterisk matches
    zero or more characters and the percent sign matches a single
    character.

    For table name specifications that contain wild card characters,
    if the first character of the string is a pound sign (#),
    the wildcard specification is changed to a "not matching"
    comparison. This allows exclusion of tables based on a wildcard
    specification. The pound sign designation is only evaluated when
    the table name specification contains an asterisk or percent
    sign.

    For exmple, a table name specification of "#FOO%" indicates that
    all table names that are four characters long and do not start
    with the string "FOO" are to be selected.

    The following table-options can be specified with the Table
    qualifier:

    o  Callback_Module=image-name, Callback_Routine=routine-name

       The LogMiner process uses the OpenVMS library routine
       LIB$FIND_IMAGE_SYMBOL to activate the specified shareable
       image and locate the specified entry point routine name. This
       routine is called with each extracted record. A final call is
       made with the Action field set to "E" to indicate the end of
       the output stream. These options must be specified together.

    o  Control

       Use the Control table option to produce output files that
       can be used by SQL*Loader to load the extracted data into an
       Oracle database. This option must be used in conjunction with
       fixed text format for the data file. The Control table option
       can be specified on either the command line or in an options
       file.

    o  Output=file-spec

       If an Output file specification is present, unloaded records
       are written to the specified location.

    o  Record_Definition=file-spec

       The Record_Definition=file-spec option can be used to create a
       record definition file for the output data. The default file
       type is .rrd; the default file name is the name of the table.

    o  Table_Definition=file-spec

       You can use the Table_Definition=file-spec option to create
       a file that contains an SQL statement that creates a table
       to hold transaction data. The default file type is .sql; the
       default file name is the name of the table.

    Unlike other qualifiers where only the final occurrence of the
    qualifier is used by an application, the Table qualifier can
    be specified multiple times for the RMU Unload After_Journal
    command. Each occurrence of the Table qualifier must specify a
    different table.
Close Help