My Oracle Support Banner

OGG Replicat Error (1460, ORA-01460: unimplemented or unreasonable conversion requested) start cursor in getColAttrsFromCatalog. (Doc ID 2412119.1)

Last updated on JUNE 19, 2018

Applies to:

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

Symptoms

Oracle GoldenGate Delivery for Oracle
Version 12.2.0.1.170221 27445592_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Feb 3 2018 00:28:11

2018-06-05 12:43:34 WARNING OGG-00869 Error (1460, ORA-01460: unimplemented or unreasonable conversion requested) start cursor in getColAttrsFromCatalog.

2018-06-05 12:43:34 ERROR OGG-00665 OCI Error executing single row select (status = 1460-ORA-01460: unimplemented or unreasonable conversion requested), SQL<SELECT c.name, c.col#, c.segcol#, c.intcol#, c.type#, c.length, 1 - c.null$ nullable, c.precision#, c.scale, c.charsetid, c.charsetform, c.property, tc.data_type, tc.data_type_owner, tc.data_precision, tc.data_length, tc.char_used, tc.char_length, opq.flags, (SELECT max(segcol#) FROM sys.col$ sc WHERE sc.obj# = o.obj# and sc.col# = c.col# and c.segcol# = 0) storage_segcol FROM sys.user$ u, sys.obj$ o, sys.col$ c, dba_tab_cols tc, sys.opqtype$ opq WHERE u.user# = o.owner# AND u.name = tc.owner AND tc.owner = :owner_name AND o.obj# = c.obj# AND o.name = tc.table_name AND tc.table_name = :table_name AND c.intcol# = tc.internal_column_id AND c.obj# = opq.obj# (+) AND c.intcol# = opq.intcol# (+) AND 1 = opq.type (+) AND o.type# in (2, 3, 4) ORDER BY c.intcol# >.

 

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!


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