Skip to Main Content

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!

control file question

user10647455Jan 27 2010 — edited Feb 3 2010
Hi guys

well my issue is i have a file which contains 10-15 fields and in my tables there is 35 fields
now when loading this file into table first two fields of file not required so in control files
my queries are
1) how i will eliminate the two fields from file??? while loading
2) as my table has more columns than file i will put filler which are not matching but is there any other way of that
please suggest

fields are terminated by
 , 
Thanks a lot!
This post has been answered by Rajesh C on Feb 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2010
Added on Jan 27 2010
12 comments
4,326 views