- symptom: ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
- cause: Local indexes can only be unique if the partitioning key is the part of the index key.
Case Study
-
This note isn’t a “real” case study, i.e. it’s not going to show you
details of the data, indexes, plans etc. from a production system, but it
is modelling...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu