SQL*Loader

I'm new to Oracle and SQL*Loader. I'm just trying to load this data (below) into an Oracle table. The problem is my "MEMO" field is seemingly too large. In Oracle I set the datatype to VARCHAR2(2000), which was not large enough. So I set the datatype in my control file to VARCHAR(3000), which works but I get this warning in my log file.

Warning on table SO_NS, column "MEMO"
Variable length field was truncated.

How do I set the field datatype so SQL*Loader imports all the data??

Thanks in advance!!

-Patti

PS I know I could look in the Server Utilities Users' Guide but our office seems to have misplaced it.

LOAD DATA INFILE * INTO TABLE so_ns FIELDS TERMINATED BY '#' TRAILING NULLCOLS
("LAST",
"FIRST",
"ENDORSEMENT",
"AFFILIATION",
"TITLE",
"VOICE",
"FAX",
"EMAIL",
"CCODE",
"BEAT",
"TOPIC",
"MEMO" VARCHAR(3000) )

BEGINDATA
B#M#CAFS#TA Inc.#Environmental Planner####us#Environment#risk communications#M B is an environmental planner and risk communications specialist with T-----A----, Inc., a S----- consulting firm. She works on a wide range of environmental issues, including solid and hazardous waste and public facilities siting. M B offers risk communication training to EPA and various state and local agencies, and presents a public workshop on understanding S------- risk assessment. B---#A-----#CASF#H------ University#Assistant professor of Economics#-#-#-#us# Economics#microeconomics, labor and public economics, environmental economics#A B is an assistant professor of economics at H------n University in H, V. She teaches microeconomics principles, intermediate microeconomics theory, labor and public economics. Professor B---- received her Ph.D. from the University of M. Her major research is in applied microeconomics and microeconomics theory, with an interest in environmental economics on issues related to environmental discrimination. Received on Tue Apr 02 1996 - 00:00:00 CEST