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@xxxxxxxxxx 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mathias Diehl Sent: 23 March 2006 15:02 To: oracle-l@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l