DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL*LOADER

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    15

    Unhappy

    Hi again,
    I am trying to extract info from five tables in the same DATABASE and insert it into an empty table i created. When I try to run sqlldr from my ms-dos it asks me for control=, this should be my control file. In short can somebody help me from here on or point me to the right direction.
    I have a select statement - it works
    I have the syntax for the control file - it looks good
    What do I do next?

  2. #2
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    It may not good for the Oracle.
    check your contro file.

    Good luck

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    Forget sqlldr. You can create that table using a "create table as select" (CTAS) statement. For example, let us suppose you have two tables such as emp and dept. emp has a dept field. You want to make one table which contains all this data.

    create table empdept as select e.id, e.empname, e.deptno, d.deptname from emp e, dept d where e.deptno=d.deptno;

  4. #4
    Join Date
    Mar 2001
    Posts
    63
    kmesser is right, the easiest way would be to use a "create table X as..." statement.

    However, to answer your earlier question, all you need to do is put the parameter line argument control=.

    If you are unsure of SQL Loader parameters, just type SQLLDR (or whatever the executable name is, depending on DB version) at the command line (without any parameters) and it will bring up some help text that explains all of the parameters.

    Good luck!

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