Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Skip Column - (not exists in table)

824061Feb 14 2011 — edited Feb 15 2011

Experts,

I have a csv data file with 5 columns and table with 4 columns.
Can i skip first column of data file and load remaining 4 columns in the table- Using SQL Loader.

I know we can use filler if column in data file and table matches. But how to do it when Column from file does not exists in the table at all and I dont want to load it.

Thanks
B

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2011

Added on Feb 14 2011

#database-key-features, #export-import-sql-loader-external-tables

7 comments

2,916 views