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.
Syntax
VIEW REPORT group_name[version]
group_nameThe 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.
versionThe relative file name if stored in the default location, or the full path name if not stored in the default location.
Examples
View the most recent (active) report.
VIEW REPORT MYEXT
View the second most recent report.
VIEW REPORT MYEXT0
View the eleventh most recent report.
VIEW REPORT MYEXT9
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