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

ORA-26708: remote DDL not supported by STREAMS : dblink string

1 Answers  


RMAN-10037: RPC anomaly detected on channel string, upinblt=number

1 Answers  


ORA-10914: invalid TABLESPACE GROUP clause

1 Answers  


ORA-24275: function 'string' parameter 'string' missing or invalid

1 Answers  


TNS-00253: Error in reading network configuration data from file string with error string

1 Answers  






DRG-11716: attempt to add Narrower Term string for non-Preferred Term string

1 Answers  


ORA-25008: no implicit conversion to LOB datatype in instead-of trigger

1 Answers  


ORA-02329: column of datatype string cannot be unique or a primary key

1 Answers  


LPX-00242: invalid use of ampersand ('&') character (use &)

1 Answers  


ORA-01911: CONTENTS keyword expected

1 Answers  


PCC-02404: This indicator variable must be declared as a pointer type

1 Answers  


ORA-22995: TABLESPACE DEFAULT option is invalid in this context

1 Answers  


Categories