Re: partitioned unique index
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 13 Oct 2010 08:55:41 +0100
Message-ID: <2radnbz6IOY5-CjRnZ2dnUVZ8oidnZ2d_at_bt.com>
Date: Wed, 13 Oct 2010 08:55:41 +0100
Message-ID: <2radnbz6IOY5-CjRnZ2dnUVZ8oidnZ2d_at_bt.com>
"alex123" <michalwert_at_poczta.fm> wrote in message
news:80fa347b-2864-4082-9356-3b164c711020_at_z28g2000vba.googlegroups.com...
>> No,
>>
>> If you want a local index to support a primary key or unique constraint
>> the partitioning column(s) have to be a subset of the primary key /
>> unique
>> column(s)
>
> So if I want to truncate partition of table with primary key I have to
> rebuild unique index on PK or use 'update global indexes'? I cannot do
> it without these options?
If you can't create the index as local that's correct .
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.comReceived on Wed Oct 13 2010 - 02:55:41 CDT