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