Nested tables configuration in golden gate
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?