SQL*Loader-00283: file processing string "string" ignored
for INFILE *



SQL*Loader-00283: file processing string "string" ignored for INFILE *..

Answer / guest

Cause: The SQL*Loader control file specified INFILE * for a
load data file along with an optional file processing
string. This message is a warning that the file processing
string will be ignored since SQLLDR will expect the data to
have the same record format as the SQL*Loader control file.

Action: If the data in the SQL*Loader control file is in the
same format as the rest of the SQL*Loader control file, then
you don't need to do anything. Removing the file processing
string will get rid of this error message. If the data in
the SQL*Loader control file has a different record format,
then you need to copy the data into a separate file and use
that file's name in the INFILE clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12072: updatable materialized view log data for "string"."string" cannot be created

1 Answers  


PCB-00314: DECLARE DATABASE is an Oracle extension

1 Answers  


ORA-36668: (XSDPART06) string is not a legal RANGE partition.

1 Answers  


TNS-00560: extraction of name from Entrust certificate failed

1 Answers  


SQL-02137: Multi-threaded agent with no RETURNING clause present

1 Answers  






ORA-01235: END BACKUP failed for string file(s) and succeeded for string

1 Answers  


CLSR-00513: Message file is not found

1 Answers  


SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string

1 Answers  


ORA-01246: recovering files through TSPITR of tablespace string

1 Answers  


ORA-04033: Insufficient memory to grow pool

1 Answers  


ORA-00106: cannot startup/shutdown database when connected to a dispatcher

1 Answers  


ORA-12057: materialized view "string"."string" is INVALID and must complete refresh

1 Answers  


Categories