Re: Creating a Very Big Partitioned PK

Ewerton Salles wrote:
>
> I have a 200 GB partitioned table in my Oracle 8i (8.1.6.2) and I will
> have to recreate my PK. Now PK uses 45 GB and I will have to add a
> column on it.
>
> I don't know if my 60GB Temporary tablespace will be enough to rebuild
> the PK.
>
> Is there any way to recreate it each partition separately ?
>
> Sent via Deja.com
> http://www.deja.com/

A hint from Johnathan Lewis's book, you can try

create index .. local unusable

and then rebuild each partition individually.

HTH
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"