Replicat Abended With ORA-01400 Error:cannot insert NULL
(Doc ID 1459309.1)
Last updated on FEBRUARY 03, 2020
Applies to:
Oracle GoldenGate - Version 10.4.0.19 and laterInformation in this document applies to any platform.
Symptoms
Replicat abend with ERROR 1400 cannot insert null:
2012-05-15 14:05:05 GGS WARNING 218 SQL error 1400 mapping <SCHEMANAME>.<TABLENAME> to <SCHEMANAME>.<TABLENAME> OCI Error OR
A-01400: cannot insert NULL into (<"SCHEMANAME">.<"TABLENAME">."SYS_NC00003$") (status = 1400), SQL <INSERT INTO "SCHEMANAME">.<"TABLENAME">
("COLUMN1","COLUMN2","STATUS","CREATE_DATE","MODIFIED_DATE","COLUMN6","COLUMN7","COLUMN8","COLUMN9>.
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 |