Results 1 to 13 of 13
  1. #1
    Join Date
    Dec 2003
    Posts
    13

    Unanswered: How to use SQL loader ?

    Hi All,

    I need to use SQL Loader inorder to convert date available in MS EXCEL into ORACLE.

    I havent used SQL Loader software till now. I dont know where this software is located or whether it is a utility software that comes along with TOAD or SQL PLUS or whether i must download or buy this software ?

    Pls suggest me the best way to transfer the data in EXCEL to ORACLE.

    Thanks in anticipation

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: How to use SQL loader ?

    SQL*Loader is installed by default. It is a command line utility, so you cannot run from within SQL*Plus or other GUI. The command is sqlldr [direct=y|n] param1 param2 param3 ...

    You should save the Excel spreadsheet as a comma separated value file (.csv) and create a SQL*Loader control file that knows the name of your .csv file and how to parse the data. See the Oracle documentation on "Utilities".
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Dec 2003
    Posts
    13
    Please allow me to clarify a few details:

    1. rename "A.xls" into "A.csv"
    clarifications reqd: is renaming alone enough as above?

    2. when you say that it is a command line utility - are you referring to running from the command prompt say:
    C:\>sqlldr
    if so, i get the message command not found....
    if not, please pass on the correct way..
    Sorry for the inconvenience but being a newbee i am finding it a bit too hard to understand the steps involved

    3. Oracle documentation for UTILITIES:
    clarification: could you pls provide me the URL where i can find it?
    i am overwhelmed by the details i see when i type oracle utilities in google. Please help!

    Thanks in anticipation.

  4. #4
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    1. Open in excel. DO as 'save as'. In file type, selected 'comma separated'.

    2. Check in bin folder of oracle installation. Do you have en exe with the name sqlldr. If not, you need to installl sql loader.

    - Other than the sql-loader installed on your PC and data file in form of CSV, you need to create a control file. This file specifies the table name and column names in which you want to insert from this data-file. This control file is one of the required parameters for SQLLDR
    Oracle can do wonders !

  5. #5
    Join Date
    Dec 2003
    Posts
    13
    Hi

    Saved as .csv file

    As for SQLLDR, i am not having it in my orant folder so now i guess i need to install sql *loader , but from where can i pick this utility?

    Guess this doesnt come along witht he Developer6i pack , since i had earlier installed this pack.

    Hoping for your response.

  6. #6
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    It comes with the deployment package.
    Try installing again using the custom installation option.

    Originally posted by sanchapanzo
    Hi

    Saved as .csv file

    As for SQLLDR, i am not having it in my orant folder so now i guess i need to install sql *loader , but from where can i pick this utility?

    Guess this doesnt come along witht he Developer6i pack , since i had earlier installed this pack.

    Hoping for your response.
    Oracle can do wonders !

  7. #7
    Join Date
    Dec 2003
    Posts
    13
    Hi

    Saved as .csv file

    As for SQLLDR, i am not having it in my orant folder so now i guess i need to install sql *loader , but from where can i pick this utility?

    Guess this doesnt come along witht he Developer6i pack , since i had earlier installed this pack.

    Hoping for your response.

  8. #8
    Join Date
    Dec 2003
    Posts
    6

    about sqlloader

    hi
    u can get all info about sqlloader at the below given link

    http://download-west.oracle.com/cd/b...96652/ch10.htm

    bye

  9. #9
    Join Date
    Dec 2003
    Posts
    13

    Re: about sqlloader

    http://download-west.oracle.com/cd/b...96652/ch10.htm

    Hi ,

    when I click the above link, it takes me to a screen which says " Page not found. (Error Document 404)"-it also says that that link might have been relocated in another place in the same site.

    Sorry to bother you but can you please provide me the changed link.....

    thanks again for your effort.

    bfn

  10. #10
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    Did you try using the search tool in the upper right hand corner???

  11. #11
    Join Date
    Jul 2003
    Posts
    2,296
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  12. #12
    Join Date
    Dec 2003
    Location
    Kekaha, Kauai, Hawaii
    Posts
    22

    SQL Loader name on NT

    On Oracle 8.0 for NT the executable is SQLLDR80.

    On Oracle 8.1 for NT the executable was renamed to SQLLDR.

    I would look in the BIN directory for anything like SQLLDR.

  13. #13
    Join Date
    Dec 2003
    Posts
    6

    sqlloader

    hi

    now u can try with this link but asap.

    http://download-west.oracle.com/docs...10.htm#1006485



    bye

Posting Permissions

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