My Oracle Support Banner

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

Last updated on MARCH 21, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.