Re: Fastunload utility for oracle - Unloading a huge table(partitioned) to a file - Can we concatenate columns?

From: ddf <oratune_at_msn.com>
Date: Tue, 16 Jun 2009 11:03:59 -0700 (PDT)
Message-ID: <649bc21a-9548-49a9-a60a-321fe5809870_at_z9g2000yqi.googlegroups.com>



On Jun 14, 9:28 am, poojam <poojama..._at_gmail.com> wrote:
> Hi,
> We have a huge table (approx ~300 million rows) with ~150 columns in
> the table.
> This table is partioned in 8 partitions.
> We need to extract one file per partition.
>
> We were planning to use Fast unload for the same. But as we need data
> in specific format we saw few constraints.
> File delimiter has been specified in the control file as caret = ^
> And we want to extract using an sql like this, but it does not work:
> select column1 , column2, column3, column4 || '|' || column5 || '|' ||
> column6 from table
> It gives a syntax error saying that || are not recognized.
>
> How can we concat 2 columns in Fastunload? Is it possible or not?
> Are there any documents where we can refer. I could find no technical
> documents on fast unload on web.
>
> ---------
> If fasunload does not support concatenating the above, should we go
> for Pro-C or Perl? Which one will be better?
> More details:
> We extracted the data of the table using fast unload and avreage row
> size is approx. 700 bytes.
> ---------
>
> Please suggest as this is urgent for one of our tasks,
> Thanking you in advance,
> Pooja

Apparently you haven't tried using the concat() function:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions026.htm#sthref1161

David Fitzjarrell Received on Tue Jun 16 2009 - 13:03:59 CDT

Original text of this message