DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: loading zip files.

  1. #11
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    The joys of UNIX-style operating systems.

    There's always a way to do what you want. It just might take you forty years to fine the correct options

    The really sad thing is I've used that import method before (years ago) and I completely forgot. Chump.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can check note 191043.1

    you can even define "-" as stdin in the controlfile then do

    Code:
    LOAD DATA
    INFILE "-"
    TRUNCATE
    INTO TABLE LDR_TEST
    FIELDS TERMINATED BY ";"
    (
      ID,
      TEXT
    )
    
    cat $1 | sqlldr scott/tiger control=LDR3.CTL

  3. #13
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    This is how my control file look like.

    load data
    infile "-"
    append
    into table test
    fields terminated by ' '
    TRAILING NULLCOLS
    (empid ,
    empname ,
    empdate)
    anandkl

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