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@xxxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Monday, August 28, 2006 6:50 AM
> Subject: Loading data usng External Tables
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
------------------------------------------------
George
george@xxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
