convchk

Use the convchk program to convert trail files from 9 digit to 6 digit checkpoint record for the named Extract group.

Syntax for Windows, UNIX, and Linux

convchk checkpoint_group trail_name (SEQLEN_9D | SEQLEN_6D) [-force]

checkpoint_group

The name of the Extract group writing the trail.

trail_name

The relative or fully qualified path name of the trail that was used with the ADD EXTRAIL command or ADD RMTTRAIL command.

seqlen_9d

Sets the sequence length to 9 digits. This is the default.

seqlen_6d

Sets the sequence length to 6 digits.

-force

Optional, not recommended. It can be used if the Extract was not stopped gracefully.

For migrating to Microservices deployment from legacy deployment or to relocate an installation to a different location

You can also use convchk to migrate from legacy deployment to a Microservices deployment, or to move an installation to different a location.

Syntax:

convchk group trail path TRAILPATH | TRAILSOURCEPATH new trail path [-force]

For SCN number overflow

The checkpoint field size needs to be changed from 32bit to 64bit after an Extract is upgraded to 19c. The field is only used by Oracle Classic Extract however the field exists for all databases' Extract checkpoints.

The convchk program update is provided in case if you need to downgrade the checkpoint file to use an older Extract. The following syntax is used:

Syntax:

convchk extract group name RESETLOGSSCNSIZE [(32BIT | 64BIT)] 

If user does not specify RESETLOG SCN size either 32bit or 64bit, then the checkpoint is not updated and the current RESETLOGS SCN size is displayed. If user specifies the RESETLOGS SCN size, the checkpoint is converted to the specified size.