OGG Extract ERROR OGG-00665 OCI Error executing single row select (status = 1460-ORA-01460: unimplemented or unreasonable conversion requested)

(Doc ID 2353981.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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

Symptoms

Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.4 14636914 OGGCORE_11.2.1.0.4_PLATFORMS_121007.2020
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Oct 8 2012 03:43:21

2018-01-27 10:12:02 ERROR OGG-00665 OCI Error executing single row select (status = 1460-ORA-01460: unimplemented or unreasonable conversion requested), SQL< SELECT nvl(iot_name, 'NULL') FROM all_tables WHERE owner = :owner AND table_name = :object_name >.

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