Add a Trail

When you create, or add, a trail, you do not physically create any files on disk. The files are created automatically by an Extract process. Rather, you specify the name of the trail and associate it with the Extract group that writes to it.

You can add a trail, while you add an Extract from the Administration Service. See Add an Online Extract.

To add a trail from the command line interface, issue the following command on the source system:

ADD {EXTTRAIL} pathname, EXTRACT group [, MEGABYTES n]

This syntax includes:

  • EXTTRAIL: This parameter specifies a trail on the local system.

  • pathname: This option is the relative or fully qualified name of the trail, including a two-character name that can be any two alphanumeric characters, for example c:\ggs\ea. Oracle GoldenGate appends a serial number to each trail file as it is created during processing.

  • EXTRACT: This option is the group name of the Extract that writes to this trail. Only one Extract group can write to a trail.

  • MEGABYTES n: This is an optional argument with which you can set the size, in megabytes, of each trail file (default is 2000).

Example: Create a Local Trail

This example creates a local trail named /ggs/ea for Extract group exte.

ADD EXTTRAIL /ggs/ea, EXTRACT exte

You can also create a local trail using REST API. For more information, see Create Trail.