How enforce uniqueness across partitions in the partition table?
From: Vadim Keylis <vkeylis2009_at_gmail.com>
Date: Wed, 31 May 2017 11:09:32 -0700
Message-ID: <CAHL4c1OwDEjEFQ86nV=T-e-hKup8ZQSq7g79mJOvh9+gHwkdDw_at_mail.gmail.com>
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?
Date: Wed, 31 May 2017 11:09:32 -0700
Message-ID: <CAHL4c1OwDEjEFQ86nV=T-e-hKup8ZQSq7g79mJOvh9+gHwkdDw_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 31 2017 - 20:09:32 CEST