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

QSM-00506: no fact-tables could be found

1 Answers  


NID-00102: Garbled target string

1 Answers  


NNO-00108: line number: TTL of number seconds below domain minimum number, using minimum

1 Answers  


ORA-02404: specified plan table not found

2 Answers  


ORA-27477: "string.string" already exists

1 Answers  


ORA-27418: syntax error in repeat interval

1 Answers  


ORA-16587: Ambiguous object specified to Data Guard broker

1 Answers  


NZE-29026: Decryption failure

1 Answers  


ORA-23419: regenerate replication support before resuming master activity

1 Answers  


LFI-01500: Error condition on call to OSD function string.

1 Answers  


ORA-09912: Malloc of name buffer(s) failed.

1 Answers  


ORA-38432: EVALUATE operator only allowed on an expression column

1 Answers  


Categories