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-30202: NULL pointer to OCIMsgh was passed to OCIMsg function

1 Answers  


RMAN-06175: deleted script: string

1 Answers  


DRG-13200: failed to load dictionary file string

1 Answers  


ORA-19604: conversation file naming phase is over

1 Answers  


NID-00604: No control files found in database

1 Answers  






RMAN-06906: backup of controlfile was cancelled

1 Answers  


ORA-16795: Database resource guard detects that database reinstantiation is required

1 Answers  


ORA-32302: object materialized views must be object ID based

1 Answers  


EXP-00105: parameter string is not supported for this user

1 Answers  


DRG-11218: malformed mail line, line string

1 Answers  


O2F-00340: Name was null

1 Answers  


IMG-00856: adjacency matrix free failed

1 Answers  


Categories