Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SqlLoader
Hello!
I tried to load a text file into my database by using sqlloader ver.
8.0.3.0.3.
This file contains a fixed variable format.
I get this error (in log file):
sql loader - 350 - syntax error at line 8.Expecting column name,
found end of file.
Anyone can help me?
Thanks.
Bye!
P.S. Check attachments for my ctl file.
e-mail:fabiana_at_ism.com.br
e-mail:flotti.rj_at_sol.com.br
begin 666 distrib.txt
M2D]!3R!,24U!($U/5$$@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M,# P,#,W.30R,CDW,C R-"\P-"\Y.$Q#3C P,# P,# P,# P,# Q-C,X-B -
M"DI/4T4_at_3%5)6B!$24%3($1!(%)/4T$@(" @(" @(" @(" @(" @(" @(" @
M(# P,#<Q-30U,S Q-S P,C0O,#0O.3A,0TXP,# P,# P,# P,# P,38R-C<@
$#0H-"@``
`
end
begin 666 ultesteF.txt
M3&]A9"!$871A#0I)3D9)3$4@)V4Z7'-E<FEO7'-E<FEO7V]R86-L95QD:7-T
M<FEB+G1X="<@#0I);G-E<G0-"DE.5$\@5$%"3$4@;V9I8VEO-PT**&YO;65? M<F%Z86\@(" @(" @(" @(" @4$]3251)3TXH,#$Z-#4I($-(05(L#0IC<&8@ M(" @(" @(" @(" @(" @(" @("!03U-)5$E/3B_at_T-CHU.2D_at_0TA!4BP-"F1A M=&%?<')O=&5S=&\@(" @(" @(" @(%!/4TE424].*#8P.C8W*2!)3E1%1T52 M($585$523D%,+ T*=&EP;R @(" @(" @(" @(" @(" @(" @4$]3251)3TXHM-C_at_Z-S I($-(05(L#0IV86QO<B @(" @(" @(" @(" @(" @("!03U-)5$E/ :3B_at_W,3HX."D_at_24Y414=%4B!%6%1%4DY!3"D`