How to handle replication when expdp generates temp table?
(Doc ID 1998385.1)
Last updated on AUGUST 18, 2021
Applies to:Oracle GoldenGate - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
When doing expdp, oracle generates temptable. if the login schema is same as replicated table owner and wildcard is used by extract and replicat, transactions related to above temp tables will be captured. this may cause replicat abend:
2015-04-10 15:33:02 INFO OGG-00506 Oracle GoldenGate Delivery for Oracle, REPLICAT-NAME.prm: Both GETTRUNCATES and DDL replication are enabled.
2015-04-10 15:33:02 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, REPLICAT-NAME.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
2015-04-10 15:33:02 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REP_NAME_r.prm: REPLICAT REP_NAME started.
2015-04-10 15:33:02 INFO OGG-01407 Oracle GoldenGate Delivery for Oracle,REP_NAME_r.prm: Setting current schema for DDL operation to [sagm].
2015-04-10 15:33:02 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, REP_NAME_r.prm: Fatal error executing DDL replication: error [Error code , ORA-08181: specified number is not a valid system change number SQL CREATE TABLE OWNER."TABLE_NAME"
) ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "DPUMP_DIR1" ACCESS PARAMETERS ( DEBUG = (0 , 47193
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