Re: text file load

From: gazzag <gareth_at_jamms.org>
Date: Thu, 6 Dec 2007 09:37:57 -0800 (PST)
Message-ID: <d597c06e-2c2b-47bb-9c15-a26693545850@e1g2000hsh.googlegroups.com>

On 6 Dec, 17:31, dx111ge <sven.andr..._at_gmail.com> wrote:
> be carefull, dumb user question:
> I have to load 4.2e data records in different tables , usually for a
> single table i would use sqlloader. But in this case i need some
> additional logic to manipulate the data records.
> Please, can somene point me into the right direction ?
>
> Thanks in advance

Oracle version?

Depending on the answer to the above, look into using External Tables:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref777

HTH -g Received on Thu Dec 06 2007 - 11:37:57 CST