ADD SCHEMATRANDATA Throws OGG-01780 Missing/Invalid argument(s) on ADD/INFO/DELETE SCHEMATRANDATA command. (Doc ID 2188988.1)

Last updated on OCTOBER 01, 2016

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

GGSCI (dgspo15l as GGS_OWNER@GPPSP03T) 3> ADD SCHEMATRANDATA GPP_OWNER ALLCOL PREPARECSN WAIT

2016-07-25 16:26:58 ERROR OGG-01780 Missing/Invalid argument(s) on ADD/INFO/DELETE SCHEMATRANDATA command.

If omit WAIT (i.e. NOWAIT), it accepts it

GGSCI (dgspo15l as GGS_OWNER@GPPSP03T) 5> ADD SCHEMATRANDATA GPP_OWNER ALLCOLS PREPARECSN

2016-07-25 16:28:35 INFO OGG-01788 SCHEMATRANDATA has been added on schema GPP_OWNER.

2016-07-25 16:29:27 INFO OGG-01976 SCHEMATRANDATA for scheduling columns has been added on schema GPP_OWNER.

2016-07-25 16:30:27 INFO OGG-01977 SCHEMATRANDATA for all columns has been added on schema GPP_OWNER.

2016-07-25 16:31:29 INFO OGG-10154 Schema level PREPARECSN set to mode NOWAIT on schema GPP_OWNER.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms