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-24157: duplicate variable name string

1 Answers  


ORA-13208: internal error while evaluating [string] operator

1 Answers  


ORA-00080: invalid global area specified by level string

1 Answers  


SQL*Loader-00406: If data is all generated, number to load cannot be ALL

1 Answers  


LSX-00117: "minLength" should not be greater than "maxLength"

1 Answers  


ORA-19210: column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'

1 Answers  


IMP-00016: required character set conversion (type number to number) not supported

1 Answers  


ORA-12041: cannot record ROWIDs for index-organized table "string"."string"

1 Answers  


ORA-01463: cannot modify column datatype with current constraint(s)

1 Answers  


AMD-00136: Generation of SQL script "string" failed

1 Answers  


ORA-19765: mount id string does not match mount id string in control file

1 Answers  


ORA-23448: duplicate user parameter value

1 Answers  


Categories