I need help loading zipped filed into my database as a blob

Hi All,
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.

Please help

Respective Control File details as follows:
.............

Load DATA
APPEND
INTO TABLE SIEBEL.EIM_ASSET
WHEN ((1) <> 'H') AND ((1) <> 'F')
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(ROW_ID RECNUM,
AST_ASSET_NUM POSITION (1),
AST_SERIAL_NUM POSITION (3:12),
X_AST_PTNR_CD POSITION (14:17),
X_PTNR_CD_EFF_DT POSITION (19:28) DATE "DD/MM/YYYY",
AST_TYPE_CD POSITION (29:38),
IF_ROW_STAT CONSTANT "FOR_IMPORT",
IF_ROW_BATCH_NUM CONSTANT "999"

1) Who is "aandkl"? and Who cares?
2) What solution?
3) I see no "BLOB"s in you table definition
4) You cannot "pipe" contents of a file into sql*loader.
5) Your control file has no "INFILE" parameter, therefore the file name defaults to the control file name and ".dat" file type.

Therefore, all you posted is incorrect, I suggest you revise it and post again.
:rolleyes:

Quote:

---

Originally Posted by LKBrwn_DBA

1) Who is "aandkl"? and Who cares?

---

The original poster tacked this onto a dead thread and I made it a new thread.
callforkarthik should have started a new thread and provided more details on what he/she was doing.

Ok gandolf...
If the "solution" was the 'zcat ... |sqlplus ...', it's obvious it would not work.

To callforkarthik:

1) Post the definition for the table into you wish to load the blob
2) State clearly your requirements.
:rolleyes: