Export Comma Delimited File to Oracle
I am having a problem regarding the export of comma delimited flat files to Oracle database by using the SQL*Loader.Please give me your suggestions/solutions regarding this.
My Table name :Temp
My data in the flat file is (Row wise)
Now how I need to export these data into Oracle.In the above 3 records some of the data is missing for some columns and also there is no comma delimited for those columns.Assume that I am having one million records to export into Oracle in n number of files.How can I do this?
If you can give the script or explain me the method it will be more useful for me.
Thanks in Advance
Click Here to Expand Forum to Full Width