load data by creating tables
I have over 50,000 files let say
tyep1. co1,co2,co3,co4 etc number of files 10,000
int, int, char, int
some of files has header only and details are blank
type2: co1,co2,co3,co4 etc number of files 30,000
char,char,init,date,date, etc
over 50 table types.
create a table for each table type on oracle is time consuming . each text files has lot of columns. Any how to load the data to oracle by creating table with understanding data type based on text file.
Appreciate any feedback.