Why the extract is not able to fetch virtual columns even with FETCHCOLS?
(Doc ID 2625939.1)
Last updated on MAY 27, 2020
Applies to:Oracle GoldenGate - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
The extract is not able to fetch virtual columns even with FETCHCOLS
It's defined like this:
"<COLUMN NAME_VC" VARCHAR2(4000 BYTE) GENERATED ALWAYS AS ("SYS"."DBMS_LOB"."SUBSTR"("<COLUMN NAME>",2000)) VIRTUAL VISIBLE
TABLE SCHEMA.TABLENAME, FETCHCOLS(<COLUMN NAME_VC>);
But Extract is not fetching this column and writing to the trail file.
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