Handling Oracle Mixed Case Tables in Oracle GoldenGate, ERROR: No viable tables matched specification. (Doc ID 1361593.1)

Last updated on JULY 16, 2012

Applies to:

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

Symptoms

Mixed case tables are supported from OGG v11.2.x onwards and so the below only applies to OGG version v11.1.x and below.

**********************************************************************************************************

When there is a mixed case table in an Oracle database, it is not possible to add the trandata for the table in Oracle GoldenGate (OGG).
When trying to add trandata it fails like

GGSCI (dosi) 8> add trandata GG.MLC_PJ_DETAIL_20110918_n
ERROR: No viable tables matched specification.

Also the extract will not capture any records for the table as it will not resolve the table.

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