Re: partitioned unique index

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Oct 2010 20:16:48 +0100
Message-ID: <o5mdnRFX6fhSLinRnZ2dnUVZ7vydnZ2d_at_bt.com>

"alex123" <michalwert_at_poczta.fm> wrote in message news:02752f68-e0c6-4d77-9c36-a87942d29934_at_g10g2000vbc.googlegroups.com...
> Hi,
>
> I have a table with is partitioned by value by one of column A. It is
> possible to create primary key on another column B which index will be
> partitioned like table?

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)

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Received on Tue Oct 12 2010 - 14:16:48 CDT

This message: [ Message body ]
Next message: group: "Ashlee Simpson NUDE........Charging $4 million For Posing"
Previous message: Mladen Gogala: "Re: Infinite loop, autonomous transactions, jobs..."
In reply to: alex123: "partitioned unique index"
Next in thread: joel garry: "Re: partitioned unique index"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message