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

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

Question Posted / guest

1 Answers
3306 Views
I also Faced
E-Mail Answers

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-02171: invalid value for MAXLOGHISTORY

1 Answers

RMAN-06011: invalid level specified: number

1 Answers

RMAN-06707: could not initialize for output file: "string"

1 Answers

ORA-06772: TLI Driver: error sending command

1 Answers

IMP-00033: Warning: Table "string" not found in export file

2 Answers

ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object

1 Answers

ORA-23351: parameter datatype string for procedure string not supported

1 Answers

ORA-16579: bad Data Guard NetSlave state detected

1 Answers

ORA-15130: diskgroup "string" is being dismounted

1 Answers

SQL*Loader-00138: Invalid value for DATE_CACHE

1 Answers

ORA-06743: TLI Driver: cannot alloc t_bind

1 Answers

PCC-02383: Expecting an expression of type OCIExtProcContext

1 Answers

For more Oracle Errors Interview Questions Click Here