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

DRG-50929: parser internal on line string on column string

1 Answers  


TNS-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


ORA-28022: cannot grant external roles to global user or role

1 Answers  


ORA-07710: sksaprs: file name buffer too small

1 Answers  


KUP-00562: unknown escape sequence

1 Answers  






ORA-08184: attempting to re-enable Flashback while in Flashback mode

1 Answers  


ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.

1 Answers  


TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

1 Answers  


ORA-14132: table cannot be used in EXCHANGE

1 Answers  


TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

1 Answers  


ORA-02031: no ROWID for fixed tables or for external-organized tables

1 Answers  


ORA-25532: MTTR specified is too large: string

1 Answers  


Categories