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.