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.
Why dont you use external tables. They are much hassle free. Assuming that you are using oracle 9i, you could try this:
create or replace directory data_dir as '/tmp'
CREATE TABLE EXTERNAL_TABLE
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY DATA_DIR
( records delimited by newline
fields terminated by ','
missing field values are null
REJECT LIMIT UNLIMITED;