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.
Ora_dude




Reply With Quote