Re: Can SQL*Loader do this?
Date: Wed, 24 Aug 2005 12:34:25 +0200
Message-ID: <430c4d31$0$24151$9b4e6d93_at_newsread4.arcor-online.net>
Hi,
in sucht cases we don't use sqlloader directly, rather we converting
this reports with Monarch into a simple CSV-Form an then loading this
file with sql loader.
Monarch is from Datawatch, look on their website (www.datawatch.com).
Volker
Snewber schrieb:
> I'm trying to load the contents of a flat text file into an oracle
> database (9.2.0.5 on Solaris).
>
> I need to transform the file contents from this file:
>
> ##########################
> # 20-08-2004 00:00:00
> # DB Name Size in Mb
> A 1
> B 2
> C 3
> ##########################
> # 21-08-2004 00:00:00
> # DB Name Size in Mb
> A 4
> B 5
> C 6
>
> to this table:
>
> DATE DB_NAME SIZE
> 20-08-2004 00:00:00 A 1
> 20-08-2004 00:00:00 B 2
> 20-08-2004 00:00:00 C 3
> 21-08-2004 00:00:00 A 4
> 21-08-2004 00:00:00 B 5
> 21-08-2004 00:00:00 C 6
>
>
> Thanks in advance
Received on Wed Aug 24 2005 - 12:34:25 CEST