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
3241 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-16064: remote archival is disabled by another instance

1 Answers

TNS-12561: TNS:unknown error

1 Answers

RMAN-08059: media recovery failed

1 Answers

ORA-14313: Value string does not exist in partition string

1 Answers

ORA-12678: Authentication disabled but required

1 Answers

ORA-30487: ORDER BY not allowed here

1 Answers

PCB-00234: FOR variable "string" is invalid type

1 Answers

ORA-14621: cannot add subpartition when DEFAULT subpartition exists

1 Answers

ORA-00040: active time limit exceeded - call aborted

1 Answers

DRG-11702: %(1)s

1 Answers

ORA-31465: cannot obtain a lock on the subscription

1 Answers

ORA-12317: logon to database (link name string) denied

1 Answers

For more Oracle Errors Interview Questions Click Here