Varchar usage
From: Ya Li Wang <ylwang_at_smi.stanford.edu>
Date: 2000/01/28
Message-ID: <Pine.GSO.4.05.10001281556120.28642-100000_at_taiyang>#1/1
>LOAD DATA
>INFILE loadtest.txt
>BADFILE'loadtest.bad'
>DISCARDFILE'loadtest.dis'
>append INTO TABLE fsv
>FIELDS TERMINATED BY ';'
>trailing nullcols
>(ID,
>frame,
>slot,
>value1 varchar,
>value2 varchar,
>owner,
>permission,
>creation_date DATE "DD-MM-YYYY",
>modify_date,
>documentation)
Record 81: Rejected - Error on table LOADTEST0, column VALUE1. Field in data file exceeds maximum length
Received on Fri Jan 28 2000 - 00:00:00 CET
Date: 2000/01/28
Message-ID: <Pine.GSO.4.05.10001281556120.28642-100000_at_taiyang>#1/1
I upload the Micro access table to Oracle database file. I met the problem, one field data type is memo in Access 97 database, with a long-line in this field. But when I upload to Oracle datafile, [Quoted] always got rejected for the reason of field length exceeds the maximium length.
Also how to define a memo data type in Oracle table structure ?
Below control file is what I have now: (Note the field called "value1" & "value2")
>LOAD DATA
>INFILE loadtest.txt
>BADFILE'loadtest.bad'
>DISCARDFILE'loadtest.dis'
>append INTO TABLE fsv
>FIELDS TERMINATED BY ';'
>trailing nullcols
>(ID,
>frame,
>slot,
>value1 varchar,
>value2 varchar,
>owner,
>permission,
>creation_date DATE "DD-MM-YYYY",
>modify_date,
>documentation)
Error message:
Record 81: Rejected - Error on table LOADTEST0, column VALUE1. Field in data file exceeds maximum length
Received on Fri Jan 28 2000 - 00:00:00 CET