RE: Varchars by SQL*Loader

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Thu, 9 Nov 2000 08:33:33 -0600
Message-Id: <10675.121571@fatcity.com>

Aren't you missing a 'terminated by' after your id_txt field?

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Javier Morales [mailto:Javier_at_infojobs.net] Sent: Thursday, November 09, 2000 4:26 AM To: Multiple recipients of list ORACLE-L Subject: Varchars by SQL*Loader

Hi,

I try to load from a file that contains one field up to 250 chars, I = tried
that controlfile...

load data
infile 'e:\oracle\paco\esp_ij011.txt'
append
into table infile_traducciones_esp
(pagina_cfm char terminated by '|', orden char terminated by '|',=20
id_txt char(5), texto varchar)

and the file format is that...

acuerdos.cfm|100|17585|InfoJobs.net - Premios y menciones
acuerdos.cfm|200|17586|Portada &gt; Sobre InfoJobs.net &gt; Acuerdos
acuerdos.cfm|300|17587|Sobre InfoJobs.net
acuerdos.cfm|400|17588|&nbsp; Acuerdos
acuerdos.cfm|500|17589|InfoJobs.net desarrolla en julio del 2000 los

servicios de bolsa de empleo para e-moción, el portal wap de Telefónica. Este servicio consta de un mneú principal = desde
el que se puede acceder a los tres apartados disponibles: ofertas destacadas, buscador de ofertas y datos y estadísticas, cuya información se actualiza en tiempo real.

The problem is that I find the data truncated BY THE BEGINNING !! :( = ...
that way...)

SVRMGR> select * from infile_traducciones_esp where rownum<=3D5;

PAGINA_CFM                   ORDEN      ID_TXT     TEXTO
--------------------------------------- ---------- ----------
-----------------------------------------------
acuerdos.cfm                     100      17585 nfoJobs.net - Premios y

menciones

acuerdos.cfm                     200      17586 ortada &gt; Sobre

InfoJobs.net > Acuerdos

acuerdos.cfm                     300      17587 obre InfoJobs.net

acuerdos.cfm                     400      17588 nbsp; Acuerdos

acuerdos.cfm                     500      17589 nfoJobs.net desarrolla =

en
julio del 2000 los servicios de bolsa de empleo para e

so, that's the best I got from it. I tried to change the ID_TXT field = to
"integer", and "char terminated by '|') but the result is even worst...

SVRMGR> select * from infile_traducciones_esp where rownum=3D1;

PAGINA_CFM                   ORDEN      ID_TXT     TEXTO
--------------------------------------- ---------- ----------
-----------------------------------------------
acuerdos.cfm                    100      17585 foJobs.net - Premios y

menciones

any suggestions???

Thanks!

Javier Morales - javier_at_infojobs.net
Administraci=D5n Bases de Datos Oracle - InfoJobs.net Tel. +34 902 10 60 90 Ext. 2067
Fax. +34 (93) 580 56 60
=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Javier Morales
INET: Javier_at_infojobs.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
Received on Thu Nov 09 2000 - 08:33:33 CST