Re: partitioned unique index
From: alex123 <michalwert_at_poczta.fm>
Date: Wed, 13 Oct 2010 00:32:16 -0700 (PDT)
Message-ID: <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)
Date: Wed, 13 Oct 2010 00:32:16 -0700 (PDT)
Message-ID: <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? Received on Wed Oct 13 2010 - 02:32:16 CDT