Re: Loading data usng External Tables

From: George <george_at_mighty.co.za>
Date: Tue, 29 Aug 2006 06:24:31 +0200 (SAST)
Message-ID: <62076.193.32.3.83.1156825471.squirrel@mail.mighty.co.za>

Hi all

thanks for all the advice so far.

currently the idea was to make the file comma deliminated.this makes for a smaller file.

From reading the comments this would not imply fixed length implying i wont be able to paralize it. comment?

> Hi George,
>
>> at the moment i am in 2 minds between create table as ... and insert /*
>> Append...
>
> in case that the target table doesn't have indexes on it I didn't observe
> a
> significant difference between those two approaches.
>
>> both is getting data from a select on a
>> external table that has parallel enabled.
>
> Make sure that the external table has a file with fixed record length as
> this is a precondition to deploy parallel select, AFAIK.
>
> Regards
>
> Jaromir
> ----- Original Message -----
> From: "George" <george_at_mighty.co.za>
> To: <oracle-l_at_freelists.org>
> Sent: Monday, August 28, 2006 6:50 AM
> Subject: Loading data usng External Tables
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

George

george_at_mighty.co.za

You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

For super low premiums, click here http://www.webmail.co.za/dd.pwm

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 28 2006 - 23:24:31 CDT