Hello
We are working on Oracle 9i database.
We have to load lots of records from an external file and one of the field contains a number of characters > 10000 .
the target table contains a long field to receive this data.
i have tried to load this records but when the number of char exceeded 4821 chars no data are visible throw a select query (with Toad Developper)
here is a sample of my CTL file
Code:
Load DATA
INFILE "/export/home/crm2adm/scripts/head.tempLIGHT3"
REPLACE INTO TABLE SW_OPPORTUNITY_LONG_WORK
fields terminated by "ยง"
-- optionally enclosed by "'"
TRAILING NULLCOLS
(
SWCUSTOMERID
,SWREASONCLOSED CHAR(10005) NULLIF SWREASONCLOSED=BLANKS
Description of my table
Code:
CREATE TABLE CRMADM.SW_OPPORTUNITY_LONG_WORK
(
SWCUSTOMERID VARCHAR2(10 BYTE) NOT NULL,
SWREASONCLOSED LONG
)
Can someone can help us ?
thanks a lot.