RE: Loading data usng External Tables

 >>>> at the moment i am in 2 minds between create table as ... 

I do huge parallel insert as select * from external tables and +APPEND is most critical.

>>>Make sure that the external table has a file with fixed
>>>record length as this is a precondition to deploy parallel
>>>select, AFAIK.

I am not aware of this restriction.

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