Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    5

    Unanswered: facing problem in the sqlldr & shell script

    Guys i am facing two problems :

    (1) when i create the sql loader file the date format i m getting is this
    28-DEC-11 12.03.14.107137 AM;
    for this i m using this script but unable to load the files

    trailing nullcols
    (
    SERIALNO,
    AMOUNT,
    CLASS,
    MDN,
    VDATE "to_date(:TIMESTAMP, 'DD-MON-YY HH24:MiS')"

    )


    (2) Another one is the name of the file is ERIC_VOUCHERDAT15
    where 15 is the date
    i want to do ftp this file from another server to my server
    for this what syantax i have to use it .

    Pls help mee guys

  2. #2
    Join Date
    Sep 2009
    Location
    Ontario
    Posts
    1,057
    Provided Answers: 1
    Code:
    ftp remote_server               
    >USER
    >PASS
    >get /tmp/file /tmp/file
    >quit
    Where remote_server is the ip address or FQDN of the machine you want to connect to.
    You will be asked for a user id and password.

    I suggest you re-ask your date question in another section.

Posting Permissions

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