RE: disable validate on a partitioned table?

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Mon, 30 Sep 2002 20:28:19 -0800
Message-ID: <F001.004DD097.20020930202819@fatcity.com>

Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C268FA.1971DB40" ------_=_NextPart_001_01C268FA.1971DB40
Content-Type: text/plain;
charset="iso-8859-1"

This is probably b/c the unique key does not include the partitioning key.

Waleed

-----Original Message-----
Sent: Monday, September 30, 2002 8:33 PM To: Multiple recipients of list ORACLE-L a partitioned table?

-----Original Message-----
>From: Khedr, Waleed [ mailto:Waleed.Khedr_at_FMR.COM
<mailto:Waleed.Khedr_at_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 ------_=_NextPart_001_01C268FA.1971DB40
Content-Type: text/html;
charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: disable validate on a partitioned table?</TITLE>

<META content="MSHTML 5.50.4915.500" name=GENERATOR></HEAD>
<BODY>
<DIV> </DIV>
<DIV>This
is probably b/c the unique key does not include the partitioning key.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Waleed</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com] Sent: Monday, September 30, 2002 8:33 PM To: Multiple recipients of list ORACLE-L Subject: [Possible Spam - go to http://spam.fmr.com] RE: disable validate on a partitioned table? </DIV> -----Original Message----- >From: Khedr, Waleed [<A
href="mailto:Waleed.Khedr_at_FMR.COM">mailto:Waleed.Khedr_at_FMR.COM</A>] > >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.</FONT> <BR><FONT size=2>&gt;--------------------</FONT> 
  <BR><FONT size=2>&gt;--------------------</FONT> <BR><FONT size=2>&gt;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
</BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C268FA.1971DB40--

------=_NextPartTM-000-b0822a90-2672-456a-b7c6-cb71656efaad--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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 - 23:28:19 CDT