I need help loading zipped filed into my database as a blob
I exactly have the same problem when i tried with the soliution given by "aandkl", I am getting an error that "command not found" while using "gzcat"
So i am using zcat instead of gzcat,but this is not working for me.I am getting the below erorr.
SQL*Loader-500: Unable to open file (TSECRDC2.dat)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
My Code is as follows:
zcat MICA_6422_SndOngoingDlrCde_20120503_194011_MICA.txt.gz | sqlldr userid=BATCH_USER/batch_user1 control=TSECRDC2.ctl log=input.log errors=10000000 bad=input.bad readsize=2500000 rows= 50000 bindsize=2500000
it means that its not recognizing the input file that i pass in command prompt and still looking for the dat file (TSECRDC2.dat) which is based on the ctl file name as given above.
Click Here to Expand Forum to Full Width