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.