RE: import

  • From: "Howard Latham" <howard.latham@xxxxxxxxxx>
  • To: <md@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 23 Mar 2006 14:51:37 -0000

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


Other related posts: