Results 1 to 7 of 7

Thread: SQL Loader

  1. #1
    Join Date
    May 2013
    Posts
    33

    Unanswered: SQL Loader

    Code:
    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.
    
    C:\Documents and Settings\Administrator>sqlplus one/two
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 13 13:33:20 2013
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL> create table me(id number,name varchar(20));
    
    Table created.
    
    SQL> host
    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.
    
    C:\Documents and Settings\Administrator>notepad one.ctl
    
    C:\Documents and Settings\Administrator>sqlldr one/two one.ctl
    
    
    SQL*Loader: Release 10.2.0.1.0 - Production on Tue Aug 13 13:35:46 2013
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    C:\Documents and Settings\Administrator>exit
    
    SQL> select * from me;
    
    no rows selected.
    In the above procedure...I have loaded the data from the datafile which contains datas that would be added into the table.

    And the datafile is

    Code:
    Satheesh,1000
    Aravind,2000
    Mohan,3000
    Ravi,4000
    Magi,5000
    when u see my above execution, the data is not loaded into the table...can anyone explain why data is not loaded into the table.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The error is obviously on line 17 of your control file.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I have loaded the data from the datafile
    No you haven't. But without seeing what you've done we can't help - at the very least you need to show us your ctl file.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Quote Originally Posted by cis_groupie View Post
    No you haven't. But without seeing what you've done we can't help - at the very least you need to show us your ctl file.
    Perhaps it's a secret control file, you may need to use your crystal ball to figure it out.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I hope the control file re-orders the columns. Your data file has the name first, and the table has a number column first.

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Quote Originally Posted by MCrowley View Post
    I hope the control file re-orders the columns. Your data file has the name first, and the table has a number column first.
    The order of the columns in the control file actually must reflect order of the fields in the source file.
    But we will never know due to this controlfile being a secret.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Post your control file if you want help!!!!
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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