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-23497: repgroup name cannot be null

1 Answers  


ORA-29270: too many open HTTP requests

1 Answers  


ORA-27039: create file failed, file size limit reached

1 Answers  


RMAN-20311: ambiguous proxy copy handle

1 Answers  


RMAN-06748: no or more than one tertiary storage channel found

1 Answers  






SQL*Loader-00555: unrecognized processing option

1 Answers  


ORA-28601: invalid [no]MINIMIZE option

1 Answers  


ORA-01181: file string created before last known RESETLOGS, cannot recreate

1 Answers  


ORA-09967: scumnt: unable to create or open file

1 Answers  


PCC-00124: COMMON_NAME option is specified too late

1 Answers  


ORA-02091: transaction rolled back

1 Answers  


ORA-13118: invalid node_id [string]

1 Answers  


Categories