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 12.3.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
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.
Changes
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 |
Changes |
Cause |
Solution |
References |