Home » RDBMS Server » Server Utilities » Re: Field in data file exceeds maximum length
Re: Field in data file exceeds maximum length [message #72019] Mon, 24 February 2003 09:00
Greg
Messages: 35
Registered: July 2000
Member
You may need to specify the length within the ctl file if the field is more than 255 chars.
Something like this:

load data
into table test_file_load
truncate
fields terminated by ","
(IP_ADDRESS,
DATE_HIT DATE 'dd/MON/yyyy:HH24:MI:SS',
SOMETHING,
STATUS,
FILE_SIZE,
DELIVERY_TIME,
PAGE char(4000))

Report message to a moderator

Previous Topic: Export without triggers (v8.0.6)
Next Topic: Export Table in Oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 22:36:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.