Results 1 to 2 of 2

Thread: SQL Loader

  1. #1
    Join Date
    May 2013
    Posts
    33

    Unanswered: SQL Loader

    Hi Everybody:
    I have datas in my text file in one of my drive which is F:\....
    But when i m trying to load data through SQL LOADER, i am not getting datas loaded into my table...Look at my code.

    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 Wed Jul 24 18:40:00 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> select * from pet;
    
    NAME                 OWNER                SPECIES              SE BIRTH
    -------------------- -------------------- -------------------- -- ---------
    DEATH
    ---------
    Fluffy               Harold               Cat                  f  04-FEB-93
    
    
    Claws                Gwen                 Cat                  m  17-MAR-94
    
    
    
    SQL> truncate table pet;
    
    Table truncated.
    
    SQL> commit;
    
    Commit complete.
    
    SQL> select * from pet;
    
    no rows selected
    
    SQL> host
    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.
    
    C:\Documents and Settings\Administrator>notepad sat.ctl
    
    C:\Documents and Settings\Administrator>sqlldr one/two sat.ctl
    
    SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jul 24 18:41:24 2013
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    C:\Documents and Settings\Administrator>exit
    
    SQL> select * from pet;
    
    no rows selected
    I dont know why i m getting datas loaded...Help me if u know.

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

    Thumbs down

    Quote Originally Posted by satheeshsharma View Post
    Hi Everybody:
    I have datas in my text file in one of my drive which is F:\....
    . . . E t c . . .
    I dont know why i m getting datas loaded...Help me if u know.
    Did you check the SQL*Loader log file?
    What does it say?
    If you keep it secret, we cannot help you.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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