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
Description of my table
REPLACE INTO TABLE SW_OPPORTUNITY_LONG_WORK
fields terminated by "§"
-- optionally enclosed by "'"
,SWREASONCLOSED CHAR(10005) NULLIF SWREASONCLOSED=BLANKS
Can someone can help us ?
CREATE TABLE CRMADM.SW_OPPORTUNITY_LONG_WORK
SWCUSTOMERID VARCHAR2(10 BYTE) NOT NULL,
thanks a lot.