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-29342: user string does not exist in the database

1 Answers  


ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD

1 Answers  


ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE

1 Answers  


ORA-16700: The standby database has diverged from the primary database.

1 Answers  


NNL-00348: Server saving the config file now

1 Answers  






TNS-00046: INTCTL: Could not contact the CMANAGER on address

1 Answers  


KUP-04102: record number discarded from file string

1 Answers  


ORA-13905: Critical or warning threshold have incorrect values

1 Answers  


IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

1 Answers  


ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.

1 Answers  


PCC-02134: CMD-LINE: Null option supplied

1 Answers  


ORA-01507: database not mounted

1 Answers  


Categories