GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Nested tables configuration in golden gate

edited Dec 17, 2013 2:48AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
We have some nested tables which needs to be configured in GG.

When we add the table into extact, we get below error:

ERROR OGG-00751 Oracle GoldenGate Capture for Oracle, isu1m_ea.prm:
Failed to validate table . Likely due to existence of unused columns. It will cause data integrity issue if you are not using sourcedefs in downstream Replicat or the target table doesn't have the same unused columns due to ASSUMETARGETDEFS or DDL replication. Please use 'DBOPTIONS ALLOWUNUSEDCOLUMN' parameter to override this.
2013-12-10 01:10:32 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle,  PROCESS ABENDING.

The nested table has only one column of NUMBER datatype. I found from Oracle documentation that Nested table having only one column can't be replicated. Is my understanding correct?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center