Re: Huge undotbs during insert

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 29 May 2005 20:08:23 +0800
Message-ID: <4299B0B7.1C22@yahoo.com>

astalavista wrote:
>
> Sorry:
> The parameter I didn't see in 9i
> is: skip_unusable_indexes

You just do (in 9i)

alter index A unusable
alter index B unusable
...
alter session set skip_unusable_indexes = true insert /*+ append */ ...

alter index A rebuild
alter index B rebuild

etc

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------

Received on Sun May 29 2005 - 07:08:23 CDT