ORACLE_SELECTION
The parameter ORACLE_SELECTION defines the tables that should be processed when reading log files for Oracle for Linux, UNIX, and Windows.
Multiple tables can be specified, separated by semicolon or comma.
During the pre-processing (output stage 1) only the records relevant to the specified tables will be retrieved from the log data.
The format is:
creator1,+tname1,+tname2,...;creator2,+tname3;....The first value is the creator of the table and the following values (separated by
commas) are the desired table names of that creator. Tables can be selected or
deselected with a + (plus) or – (minus) sign.
Multiple creators can be separated by a semicolon. Multiple tables within a creator
are separated by a comma. Table names can also be generically defined, e.g.
+SYS*.
Example:
ORACLE_SELECTION = 'SYSTEM,+ALL_TAB,+MUL_TAB;'
ORACLE_SELECTION = 'SYSTEM,+MUL*,-MUL_TAB;'This parameter may be used with Input_Source_Type = ''ORA_LOGM',
Input_Type = 'ORACLE_LOGREC', or if the input data comes from a
remote data script that sends the data in the internal stage 0 format.