Title: RE: disable validate on a partitioned table?
Try
this before exchanging segments:
alter
table country_temp add (constraint country_uq2 unique (country_founded) disable
validate) ;
Waleed
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Tuesday
Title: RE: disable validate on a partitioned table?
-Original Message-
>From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
>
>This is probably b/c the unique key does not include the partitioning key.
The unique key did include the partitioning key. Here is my exampl
Title: RE: disable validate on a partitioned table?
This
is probably b/c the unique key does not include the partitioning
key.
Waleed
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 30, 2002
8:33 PMTo: Multiple recipients of
Title: RE: disable validate on a partitioned table?
-Original Message-
>From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
>
>As you know for a partitioned table: unique constraints
> could be enforced by a local index or global index.
>
>For local index: the unique k
Title: disable validate on a partitioned table?
As you
know for a partitioned table: unique constraints could be enforced by a local
index or global index.
For
local index: the unique key will be part of the partitioning
key.
So for
a partitioned