- 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.
Partition by Expression
-
Oracle 26.1 now allows using an *Expression* in the Partitioning Clause.
In earlier releases, you could do this with a Virtual Column defined in the
ta...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu