Results 1 to 9 of 9

Thread: Sql loader

  1. #1
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Sql loader

    Hello,

    Do we need to install sql loader seperately or does it install automatically while installing oracle 9i?


    Regards
    Babi


  2. #2
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Sql loader

    sql loader is a bulk loader utility to moving data from external files to oracle database and is installed along with the oracle 9i software


  3. #3
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Re: Sql loader

    How to start sql loader?


  4. #4
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Sql loader

    From command prompt run

    sqlldr user/passwd control=example.ctl log=example.log data=example.dat

    sqlldr is in bin folder in oracle 9i


  5. #5
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Re: Sql loader

    I created a CSV file from which data to be imported. Do I need to copy that file to bin folder?


  6. #6
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Re: Sql loader

    Typing the following command at sql prompt throughs error message.

    Sqlldr username/password control = loader.ctl

    Error :- Unable to open file loader.ctl

    Is it must to create a new control file or else comes with default control file?


  7. #7
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Sql loader

    u need to specify the path (i.e control=c:\example.ctl) or copy the file in bin


  8. #8
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Re: Sql loader

    The following control file is working fine for CSV files.

    load data
    infile 'd:\one.csv'
    into table emp
    fields terminated by "," optionally enclosed by '"'
    ( EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)


    To load DBF file data
    infile 'd:\one.dbf' modification is enough or do I need to do any other modifications in the above control file?


  9. #9
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Re: Sql loader

    fields terminated by "," optionally enclosed by '"' line also may not work?

    Could anyone please post model control file for loading DBF data.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact