SQL*Loader-00802: numeric EXTERNAL with DEFAULTIF clause not
supported by External Table



SQL*Loader-00802: numeric EXTERNAL with DEFAULTIF clause not supported by External Table..

Answer / guest

Cause: A numeric EXTERNAL type was specified with a
DEFAULTIF clause and that is not supported by External Table
Load.

Action: Remove the clause if possible or do not use External
Table Load.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12207: TNS:unable to perform navigation

1 Answers  


ORA-00061: another instance has a different DML_LOCKS setting

1 Answers  


ORA-24347: Warning of a NULL column in an aggregate function

1 Answers  


PLS-00722: supertypes's AUTHID is different than subtype's AUTHID

1 Answers  


TNS-01093: %s * string * number

1 Answers  






ORA-31640: unable to open dump file "string" for read

1 Answers  


ORA-06421: NETCMN: Error detected in the read-in data

1 Answers  


LPX-00005: ~1s buffer overflow, maximum size is ~2u bytes

1 Answers  


ORA-30134: reserved for future use

1 Answers  


TNS-03508: Failed to create address string

1 Answers  


DRG-13010: alt_value is already used by another sub lexer

1 Answers  


ORA-12065: unknown refresh group identifier string

1 Answers  


Categories