Re: Loading data usng External Tables

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Mon, 28 Aug 2006 23:26:59 +0200
Message-ID: <0f2701c6cae8$b477a080$3c02a8c0@JARAWIN>

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

Received on Mon Aug 28 2006 - 16:26:59 CDT