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

ORA-29870: specified options are only valid for altering a domain index

1 Answers  


ORA-39037: Object type path not supported for string metadata filter.

1 Answers  


LFI-01519: llseek() failed(OSD return value = string) in string.

1 Answers  


ORA-24167: incompatible rule engine objects, cannot downgrade

1 Answers  


RMAN-02001: unrecognized punctuation symbol "string"

1 Answers  






ORA-00255: error archiving log string of thread string, sequence # string

1 Answers  


ORA-07476: slsget: cannot get mapped memory statistics.

1 Answers  


EXP-00030: Unexpected End-Of-File encountered while reading input

1 Answers  


ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

1 Answers  


TNS-01106: Listener using listener name string has already been started

1 Answers  


DRG-11822: Forbidden

1 Answers  


ORA-00741: logfile size of (string) blocks exceeds maximum logfile size

1 Answers  


Categories