I need help loading zipped filed into my database as a blob
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Jun 2013
    Posts
    2

    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

  2. #2
    Join Date
    Jun 2013
    Posts
    2
    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"

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool

    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.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Quote Originally Posted by LKBrwn_DBA View Post
    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.
    this space intentionally left blank

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool

    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.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width