Re: SQLLDR control file syntax
From: FC <flavio_at_tin.it>
Date: Tue, 21 Jan 2003 08:45:40 GMT
Message-ID: <UM7X9.80411$AA2.3646681_at_news2.tin.it>
... and so on...
INTO TABLE... bla bla bla
Date: Tue, 21 Jan 2003 08:45:40 GMT
Message-ID: <UM7X9.80411$AA2.3646681_at_news2.tin.it>
INFILE clauses must appear close to each other. Moreover the record layout must be the same.
INFILE file1.dat INFILE file2.dat BADFILE file2.bad INFILE file3.dat DISCARDFILE file3.dis
... and so on...
INTO TABLE... bla bla bla
This is because the feature is meant to simplify the loading of multiple
files sharing the same structure.
If there is no way to detect whichever is 'N' from the file content, then
you must split the control file in two pieces.
Bye,
Flavio
Received on Tue Jan 21 2003 - 09:45:40 CET