VIEW REPORT

Use VIEW REPORT to view the process report or the discard filet hat is generated by Extract or Replicat. Each process generates a new report and discard file upon startup.

Reports and discard files are aged whenever a process starts. Old files are appended with a sequence number, for example finance0.rpt, finance1.rpt, and so forth, or discard0.dsc, discard1.dsc, and so forth. To view old files, use the [n] option. To view the current report or discard file, use the command without the [n] option.

Syntax

VIEW REPORT {group_name[n] | file_name}

group_name: The name of the Extract or Replicat group. The command assumes the report file named group.rpt or the discard file named group.dsc in the Oracle GoldenGate dirrpt sub-directory.
n: The number of an old report. Report files are numbered from 0 (the most recent) to 9 (the oldest).
file_name: The relative file name if stored in the default location, or the full path name if not stored in the default location.

Examples

Example 1

The following displays an old report file (number 3) for the orders group.

VIEW REPORT orders3

Example 2

The following displays a specific discard file identified by its file name. Note that the file name has a non-default file extension.

VIEW REPORT dirrpt\orders.rpt