My Oracle Support Banner

PostgreSQL - "Table <Schema>.<tablename> does not exist in target database" - When Using Tables With Underscore (Doc ID 2896400.1)

Last updated on JANUARY 11, 2023

Applies to:

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

Symptoms

OGG abends with the following error

WARNING OGG-00869 Could not retrieve definition for table testschema.ggtest_1
2022-09-01 17:06:24 ERROR OGG-00199 Table testschema.ggtest_1 does not exist in target database.

Basically tables with underscore cannot be identified.

If using a table which does not have underscore, it works all fine.

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.