hi, i have a control file that takes in duplicated column names. Is there anyway to skip one of them, as in when the sql loader sees that column name, skips it and continues to load the rest of the data but it will take in the data at the next occurance of that duplicated column.
to scip column from datafile with delimiters you can use FILLER type in control file. So instead of specifying data type like INTEGER or CHAR you can specify FILLER. But this will work only in Oracle8, not in Oracle7.