RE: import

Try sqlloader.

Howard A. Latham

SENIOR DATABASE ADMINISTRATOR
RSMB Television Research Ltd,
The Communications Building,
48 Leicester Square,
London. WC2H 7LT  

Tel: +44 (0)20 7808 3619
SW:  +44 (0)20 7808 3600
Fax: +44 (0)20 7839 7446

mailto:Howard.latham_at_rsmb.co.uk

http://www.rsmb.co.uk

Email Disclaimer

This email has been sent from RSMB TV Research , a UK limited liability company. The information in
this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mathias Diehl Sent: 23 March 2006 15:02
To: oracle-l_at_freelists.org
Subject: import

Hi List,

even though my question is pretty sure a RTFM question I would appreciate
your help.

I need to import larger .txt files (>65MB) with a special format.

each line beginn's with a kind two digit code indicating the type of line.
According to this type the rest of the line has fixed sizes per field.

Could someone please help me how to import such a stuff (without urging me
to read the whole SQL book).

thanx

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 23 2006 - 08:51:37 CST