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

CLSR-00518: Failed to register a preconnect service name

1 Answers  


ORA-09859: sfngat: the input file name is not in the autobackup OMF format

1 Answers  


ORA-31423: change table string does not contain column string

1 Answers  


ORA-36820: (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.

1 Answers  


ORA-16719: unable to query V$ARCHIVE_DEST fixed view

1 Answers  


ORA-14009: partition bound may not be specified for a LOCAL index partition

1 Answers  


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

1 Answers  


ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.

1 Answers  


ORA-31216: DBMS_LDAP: PL/SQL - Invalid LDAP rdn.

1 Answers  


PLS-00461: mismatch REPEATABLE information between specification and body of 'string'

1 Answers  


ORA-09776: pws_look_up: access error on (Oracle helper) executable

1 Answers  


KUP-04026: field too long for datatype

1 Answers  


Categories