Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

O2I-00112: Unable to write to the HFILE file

1 Answers  


ORA-16400: quota attributes are not allowed with DB_RECOVERY_FILE_DEST

1 Answers  


EXP-00000: Export terminated unsuccessfully

1 Answers  


ORA-08206: ora_addr: cannot translate address file name

1 Answers  


LPX-00274: can't import node type

1 Answers  






ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.

1 Answers  


ORA-02356: The database is out of space. The load cannot continue

1 Answers  


EXP-00075: rounding FILESIZE down, new value is string

1 Answers  


ORA-04099: trigger 'string' is valid but not stored in compiled form

1 Answers  


ORA-22610: error while adding a scalar to the image handle

1 Answers  


ORA-02093: TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)

1 Answers  


RMAN-06743: specification does not match any backupset in the repository

1 Answers  






Categories