Skip to Main Content
Forums

SQL & PL/SQL

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!

Multiple flat files with header rows into External Table

Ricky007Jul 25 2017 — edited Jul 25 2017

Dear experts,

I have an external table set up for a multiple file at the moment with a skip 1 to ignore the header record.

We have second data file in the same format which I would like to add to the same external table however the skip 1 only seems to apply to the first file and does not skip the

header record for the second file. Is there any other way I can load both these files into the table and skip the header lines on both files?

please help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2017
Added on Jul 25 2017
3 comments
1,042 views