We are using version 11.2.0.4 of Oracle Exadata. We have a requirement in which we want to create a table which will be daily range partitioned on a date column. As the data volume is going to be ~100million+ per day and also may increase further so we want to partition it in correct way for its future maintenance and querying purpose. But we also want to make sure all the indexes in that table to be local so that it wont give us trouble in case of future maintenance(as because we have difficulties due to many global indexes in partitioned table during maintenance so we avoid those).
As per data architecture requirement there has to be a unique/primary key created on the table as per business need. Now the issue is that Oracle doesn't allow us to have the UNIQUE key/index created independently localized to the partition. It asks us to include the partition key in the index definition, but that violates the business need . So want to know from experts , if there is anyway we can achieve the data uniqueness(for non partition key columns) along with the underlying index being created as local in same partition table?