1.112 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.

Syntax

VIEW REPORT group_name[version] 
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.

version

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   

View the most recent (active) report.

VIEW REPORT MYEXT
Example 2   

View the second most recent report. 

VIEW REPORT MYEXT0
Example 3   

View the eleventh most recent report.

VIEW REPORT MYEXT9
Example 4   

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