SQL*Loader-00254: Cannot have DISCARDFILE specs here when
multiple data files



SQL*Loader-00254: Cannot have DISCARDFILE specs here when multiple data files..

Answer / guest

Cause: The SQL*Loader control file contained multiple INFILE
statements and a DISCARDFILE statement was found below the
RESUME clause.

Action: Move the DISCARDFILE statement above the RESUME
clause, so it is adjacent to one of the INFILE statements.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-01057: Foreign data items cached: number

1 Answers  


QSM-02162: the detail table does not have a materialized view log

1 Answers  


O2F-00341: An error occurred for which no message is available

1 Answers  


RMAN-06537: CHANGE ... KEEP not supported for BACKUP

1 Answers  


ORA-16805: Change of LogXptMode property violates overall protection mode.

1 Answers  


ORA-02774: Invalid request list latch time out value

1 Answers  


ORA-08340: This command not allowed on nCUBE, only one thread is ever used.

1 Answers  


ORA-02026: missing LINK keyword

1 Answers  


PCB-00301: Use of non-ANSI function is an Oracle extension

1 Answers  


UDI-00002: invalid username or password

1 Answers  


NNL-00342: Log file name is currently string

1 Answers  


ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

1 Answers  


Categories