Re: What's quicker, table to table insert or extract and sqlload?
From: Yuk Hon Johnny Chan <jychan_at_corp.hp.com>
Date: 1996/03/01
Message-ID: <4h5kag$7ed_at_hpcc48.corp.hp.com>#1/1
Date: 1996/03/01
Message-ID: <4h5kag$7ed_at_hpcc48.corp.hp.com>#1/1
:
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
: 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 ??
Independent Oracle Specialist
Received on Fri Mar 01 1996 - 00:00:00 CET