SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause
specified for nested table column string



SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause specified for nested table column string..

Answer / guest

Cause: Rows in a nested table annot be set to NULL. SQLLDR
displays this error when a NULLIF clause was specified for
the element that defines the row that make up a nested
table. SQLLDR also displays this error if a DEFAULTIF clause
is specified for an element that is a named type, since
SQLLDR will set a named type to NULL if the DEFAULTIF
evaluates to TRUE.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00330: The following datafiles are offline immediate:

1 Answers  


RMAN-08508: archive log destination=string

1 Answers  


ORA-12994: drop column option only allowed once in statement

1 Answers  


LPX-00265: read failed from to host ~s

1 Answers  


NZE-29116: Cannot get PKCS #12 attributes.

1 Answers  






ORA-26011: Cannot load type string into column string in table string

1 Answers  


SQL*Loader-00554: error opening file

1 Answers  


ORA-16602: Object must be disabled to perform this operation.

1 Answers  


ORA-16704: Cannot set the property because it is read-only

1 Answers  


ORA-22858: invalid alteration of datatype

1 Answers  


NNL-00306: Server setting all statistic counters to zero

1 Answers  


ORA-13292: incorrect ARC_TOLERANCE specification

1 Answers  


Categories