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

HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G, WIN XP OS. PLS HELP ME TO SOLVE THIS PROBLEM. AM NEW TO DBA ACTIVITIES

1 Answers  


EXP-00085: The previous problem occurred when calling string.string.string for object number

1 Answers  


ORA-25102: PARALLEL option can only be used with ALTER INDEX REBUILD

1 Answers  


ORA-16172: archive logs detected beyond Terminal End-Of-Redo

1 Answers  


ORA-34719: (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion

1 Answers  


KUP-11011: file string is not valid for this load operation

1 Answers  


ORA-40208: duplicate or multiple algorithm settings for function string

1 Answers  


LSX-00220: "~1S" is wrong length, should be ~2d

1 Answers  


TNS-12668: Dedicated server: outbound protocol does not support proxies

1 Answers  


ORA-27091: unable to queue I/O

1 Answers  


PLS-01702: Illegal syntax in COMMIT WORK statement

1 Answers  


ORA-29886: feature not supported for domain indexes

1 Answers  


Categories