Re: Loading data usng External Tables

George,
you can parallel either format (csv or fixed length), Fixed length is much faster as the system will not have to scan the data to find out the ',' to delimit each field.

rgds

On 8/29/06, George <george_at_mighty.co.za> wrote:
>
> 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
>
> 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
>
>
>

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