Re: What's quicker, table to table insert or extract and sqlload?

Yuk Hon Johnny Chan wrote:
>
> :
> : NOTE : According to _Oracle : The Complete Reference_ (Koch&Looney), the
> : 'create table ... as select * from ...unrecoverable' option
> : suggested by Mr. Chan will be the fastest since no redo log
> : entries
> : are generated. It makes no mention of rollback segments. I
> : suspect
> : that since this is a DDL and the operation cannot be rolled back,
> : there is no use of rollback segments - any feedback on this ??
>
> that's correct...this should apply even to pre-7.2 versions. the
> unrecoverable option provides the additional benefit of no redo
> generation, which can be significant.
>
> Johnny Chan
> Independent Oracle Specialist

also what is not noted (at least in this fragment of the original) is that oracle has parallelized the 'create table as select', so on a smp box it can really scream !!!

-m
-- 
--------------------------------------------------------------------------------
michael de young brown				silicon graphics
tel:	415 933 5507				network systems division
fax:	415 390 6320				mikebr_at_sgi.com

"that which does not kill you makes you stronger." 	- f. nietzsche
"im not dead yet..."					- m. python
--------------------------------------------------------------------------------