Re: How enforce uniqueness across partitions in the partition table?

I assumed as much when you said interval partitioning. That shouldn't prevent you from including the partition key in compound unique index. But Stefan also makes a good point with the new 12c features.

Don.

On Wed, May 31, 2017 at 1:31 PM, Vadim Keylis <vkeylis2009_at_gmail.com> wrote:

> Hi Don. Forgot to mention that table partition by date.
>
> On Wed, May 31, 2017 at 11:19 AM, Don Seiler <don_at_seiler.us> wrote:
>
>> You can have locally partitioned unique indexes, you just need to include
>> the partition key in them.
>>
>> Don.
>>
>> On Wed, May 31, 2017 at 1:09 PM, Vadim Keylis <vkeylis2009_at_gmail.com>
>> wrote:
>>
>>> Good morning. We have table that is partition using interval partition.
>>> Older partition will be dropped on regularly. What is the best practice to
>>> enforce uniqueness across partitions considering that global index is not
>>> an option since it becomes invalid once partition is dropped?
>>>
>>> Thanks so much in advance,
>>> Vadim
>>>
>>
>>
>>
>> --
>> Don Seiler
>> www.seiler.us
>>
>
>

-- 
Don Seiler
www.seiler.us

--
http://www.freelists.org/webpage/oracle-l