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

ORA-01879: the hh25 field must be between 0 and 24

1 Answers  


NNO-00613: disabling FORWARDING-DESIRED on system queries

1 Answers  


PLS-01403: Comment delimiters /* */

1 Answers  


QSM-01509: equivalence, string, matched query text

1 Answers  


ORA-09850: soacon: Archmon unable to lock named pipe.

1 Answers  






ORA-02464: Cluster definition can not be both HASH and INDEX

1 Answers  


PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


ORA-24389: Invalid scrollable fetch parameters

1 Answers  


ORA-38490: invalid name: quotes do not match

1 Answers  


TNS-01179: Listener cannot load instance class "string"

1 Answers  


RMAN-06223: starting up automatic instance string

1 Answers  


NZE-29021: Secret key length is incorrect when using SSL 2.0.

1 Answers  


Categories