home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 686 of 2,288   
   Tomo to All   
   sql*loader utillity for importing text f   
   18 Nov 03 21:08:28   
   
   From: tomislav.kokoska@vz.hinet.hr   
      
   I'm trying to import text file into some oracle table.   
   I created control file, and text file, create table ..and run sqlldr80 from   
   command promt..   
   Imort was not succesfull..error occurs..sql*loader-524:partial record found   
   at end of data file (proba.ctl)   
   See what i done, and please help me..   
   CREATING TABLE   
   *******************   
   create tabale example(   
   column1 number(3),   
   column2 char(3))   
   *******************   
   CREATING CONTROL FILE   
   *******************   
   LOAD DATA   
   INFILE 'EXAMPLE.DAT'   
   INTO TABLE EXAMPLE   
   (COLUMN1  POSITION (01:03) INTEGER EXTERNAL,   
    COLUMN2 POSITION (04:06) CHAR)   
   *********************   
   CONTENT OF EXAMPLE.DAT FILE (after "C" Carriage Return)   
   ********************   
   123ABC   
   234DEF   
   ********************   
   text written in command prompt   
   *********************   
   sqlldr80 tomo/kokos@beq-local.world control = 'example.ctl'   
   data='example.dat'   
   *******************   
   all files are placed in root c:\   
   PLEASE HELP ME!! WHERE I DID IT WRONG?!!   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca