Hi,
My db version is : oracle 11g
I have a 6 gig csv file.
I split it to several 15mb csv files.
But only the very first csv file has header (with column headings).
I have to load each of these files into a target table.
I created a external table with skip 1.
But how can I override skip 1 for other csv files.
Is there a way I can do it in the external table definition.
I cannot merge the split csv files and run it as one big file. So i dont hv that option. Please advice.