Loading Long fields using SQLOADER help

From: Karen Payten <karen_at_metz.une.edu.au>
Date: 2 May 94 04:14:06 GMT
Message-ID: <4554_at_grivel.une.edu.au>

Jeff,

I have loaded longs using sqlloader, but I must admit my long's were not VERY long. I restricted them to 10,000. The ctl file looked like:

---

load data
infile inst.dat
badfile inst.bad
discardfile inst.dsc
append
continueif next (1) = "*"

into table tinst
fields terminated by "#"

	(name, type,
	comments char (10000),
	contact_text,
	contact_addr_1, contact_addr_2, contact_addr_3,
	contact_addr_4, contact_addr_5,
	contact_phone_1, contact_phone_2, contact_phone_3,
	contact_fax terminated by '#',
	seqnum sequence (max,1)) 
----------------------------

The data file inst.dat looked like:

---

 MONASH DISTANCE
*EDUCATION, VIC#U#
*As a result of an affiliation agreement between Monash University and Gippsland
*Institute of Advanced Education, Monash-Gippsland was designated in April 1989 as
*a national Distance Education Centre. Gippsland's long-standing commitment as a
*provider of external courses continues under the Distance Education Centre which
*will now include distance courses initiated and taught by staff from all campuses of
*the University.
*Monash University has campuses at Clayton, Caulfield and Frankston and the
*Monash University College Gippsland which is situated at Churchill in eastern
*Victoria. Weekend and vacation schools are held on a regular basis to support
*distance education courses and there are extensive support systems for this mode of
*study.
*Applicants are expected to have successfully completed the Victorian Certificate of
*Education (or equivalent). Mature age entry provisions also apply. Applications for
*distance education must be submitted to The Registrar, Monash University College
*Gippsland by 18 October 1991.#
*For further information contact:#
*The Registrar#
*Monash University College Gippsland#
*Switchback Road#
*Churchill VIC 3842 # #
*Telephone: (051) 22 6287 Registrar's Office#
*(051) 22 6274 Distance Education Resources Centre# # #

---

I have never tried to load anything that has bigger long type data than this, but I hope this helps.

Regards Karen

---

Karen Payten
Database Administrator
Computing and Communication Services
University of New England, Armidale NSW
Email: karen_at_metz.une.edu.au Phone: +61 67 733549

---

Received on Mon May 02 1994 - 06:14:06 CEST