partitioned unique index

#1

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?

#2

On Mon, 11 Oct 2010 04:43:51 -0700, alex123 wrote:

Quote:

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?

You can create a global unique index or you can create a unique prefixed
local index.

--
http://mgogala.byethost5.com

#3

"alex123" <michalwert (AT) poczta (DOT) fm> wrote

Quote:

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

#4

On Oct 12, 12:16*pm, "Jonathan Lewis" <jonat... (AT) jlcomp (DOT) demon.co.uk>
wrote:

Quote:

"alex123" <michalw... (AT) poczta (DOT) fm> wrote in message

news:02752f68-e0c6-4d77-9c36-a87942d29934 (AT) g10g2000vbc (DOT) 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)

Of course I have no idea what I'm talking about, but wondering if this
is a use for cube-organized materialized views. I'm guessing that
since minimax operators are a type of aggregator, there might be a way
to effectively repartition with the mview: http://www.rittmanmead.com/files/COMV_PAPER.pdf

jg
--
@home.com is bogus.
http://threatpost.com/en_us/blogs/tw...-500000-092110

#5

Quote:

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?

#6

"alex123" <michalwert (AT) poczta (DOT) fm> wrote

Quote:

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.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

partitioned unique index

comp.databases.oracle.server comp.databases.oracle.server

partitioned unique index - 10-11-2010 , 06:43 AM

Re: partitioned unique index - 10-11-2010 , 11:46 AM

Re: partitioned unique index - 10-12-2010 , 02:16 PM

Re: partitioned unique index - 10-12-2010 , 04:32 PM

Re: partitioned unique index - 10-13-2010 , 02:32 AM

Re: partitioned unique index - 10-13-2010 , 02:55 AM