| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: disable validate on a partitioned table?
-----Original Message-----
>From: Khedr, Waleed [mailto:Waleed.Khedr@FMR.COM]
>
>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 table with a unique key that is a part
> of the partitioning key, Loading a partition or exchanging
> it does not require a full table scan or reading all partitions.
>
>Uniqueness will be checked in memory during the load/exchange
> process for only one partition.
I see. So it will require a "full partition" scan but not a full table scan. That makes sense.
In any case my question was moot because I was unable to do an "alter table ... exchange partition ... " on a table with a disable validate key, even though the documentation says that's one of the times when it would be useful. When I tried doing the exchange partition I received
ORA-25132 UNIQUE constraint (JRK.COUNTRY_UQ1) disabled and validated in ALTER TABLE EXCHANGE PARTITION
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jacques Kilchoer INET: Jacques.Kilchoer_at_quest.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Sep 30 2002 - 19:33:20 CDT
 |
 |