My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


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.


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

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