SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause
specified for nested table column string
- 1 Answers
- 3120 Views
- I also Faced
- E-Mail Answers
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 |
NNF-00110: no values exist
ORA-31676: illegal value for number of workers, string
ORA-12329: database string is closed; no operations are permitted
ORA-16519: the resource handle is invalid
NCR-03005: NCRO: Orphan message
QSM-02052: subquery using a select list in mv
DRG-11512: bad syntax for thesaurus load file at line string
PCC-00039: Unable to open input file "string"
RMAN-06119: uncataloged datafile copy
IMG-00845: internal image index allocation failed
ORA-33306: (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string.
LSX-00027: property "~s" unknown
Oracle Errors 
