| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Loading data usng External Tables
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?
G
> 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_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!
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 28 2006 - 23:24:31 CDT
 |
 |