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

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
>

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