Re: Help with Data Manager

From: Len Wickens <len_at_cyber-wizard.com>
Date: 1997/12/16
Message-ID: <676rli$30m2_at_crash.videotron.ab.ca>#1/1


Have you tried utl_file to read it from within oracle, this will also allow formatting/processing of data prior to insertion in the database

--
Len Wickens
Senior Oracle/Unix Analyst
Object Oriented Programming Systems Corp

Michael Will de Laforcade wrote in message
<676m1a$o6f$1_at_client2.news.psi.net>...

>hi,
>
>I am trying to use SQL*Loader ver 7.3.2.2.0 to load data into an Oracle 8
>server.
>
>I keep on getting the following error (ORA-00942 table or view does not
>exist) for the simplest tables and load files.
>
>Ther tables in question DO exist.--- go figure.
>
>Is there a basic incompatibility?
>
>Does anyone know a better utility for loading CSV files into Oracle8.
>
> Thanks in advance...Michael.
>
>
begin 666 Leonard Wickens.vcf M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E=I8VME;G,[3&5O;F%R9 T* M1DXZ3&5O;F%R9"!7:6-K96YS#0I/4D<Z3V)J96-T($]R:65N=&5D(%!R;V=R M86UM:6YG(%-Y<W1E;7,_at_0V]R< T*5$E43$4Z4V5N:6]R($%N86QY<W0-"E1% M3#M(3TU%.U9/24-%.C0P,RTT.#DM,SDY.0T*5$5,.T-%3$P[5D])0T4Z-# S M+CDT,"XR.3DX#0I!1%([5T]22SH[-# S+C0X.2XS.3DY#0I,04)%3#M73U)+ M.C0P,RXT.#DN,SDY.0T*14U!24P[4%)%1CM)3E1%4DY%5#IL96Y 8WEB97(M M=VEZ87)D+F-O;0T*14U!24P[24Y415).150Z;&5N0'8M=V%V92YC;VT-"D5- M04E,.TE.5$523D54.F]O<'-?7T!V+7=A=F4N8V]M#0I2158Z,3DY-S$R,394 4,C$R.#(S6_at_T*14Y$.E9#05)$#0H` ` end end
Received on Tue Dec 16 1997 - 00:00:00 CET

Original text of this message