Classic Extract Abends With Error RAC Doesn't Support Parallel Direct Load Of Table when CTAS
Last updated on AUGUST 23, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Classic Extract not supports CTAS in a Bi-Directional Replication.
For example, below is the example with a 2 Node RAC.
From site1 (source) triggered following sql statements: create table supplier, insert, update, delete and it was successfully replicated to site2 (targert)
Next from site2 (source) triggered following sql statements: : insert into supplier, create table gg_ddl_test as select * from supplier and it got replicated to site1.
Then from site1 triggered: insert or truncate of table gg_ddl_test causes extract to abend with OGG_1875 error
2017-04-25 11:17:50 INFO OGG-01517 Position of first record processed for Thread 2, Sequence 2897, RBA 1335247888, SCN 0.99240734 (99240734), Apr 24, 2017 10:20:30 AM.
Source Context :
SourceModule : [er.redo.ora.sr]
SourceID : [/scratch/debassah/view_storage/debassah_solarisx64fbo/oggcore/OpenSys/src/app/er/redo/oracle/redoorasr.c]
SourceFunction : [get_direct_load_insvals]
SourceLine : 
2017-04-25 11:17:50 ERROR OGG-01875 Classic Extract doesn't support RAC parallel direct load of table.
2017-04-25 11:17:50 INFO OGG-01055 Recovery initialization completed for target file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt000005172, at RBA 1448.
2017-04-25 11:17:50 INFO OGG-01478 Output file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt is using format RELEASE 12.2.
2017-04-25 11:17:50 INFO OGG-01026 Rolling over remote file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt000005172.
2017-04-25 11:17:50 INFO OGG-01053 Recovery completed for target file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt000005173, at RBA 1448.
2017-04-25 11:17:50 INFO OGG-01057 Recovery completed for all targets.
There is no parallel load performed in the database, but still the Extract process abends with the below error when a CTAS is performed.,
ERROR OGG-01875 Classic Extract doesn't support RAC parallel direct load of table.
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