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.
11-03-2000, 08:31 AM
As far as I know there is no way to skip columns from datafiles.
A possible workaround is this:
load the data as it is into a temporary table
issue the create table as select col1, col2 col3.... from temp_table, omitting the column that you do not want.
Try this and see if it works.
11-03-2000, 06:41 PM
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.