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