- 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.
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in
Oracle 19c and earlier
-
Here’s a little PL/SQL function create_partition_high_value_func.sql that
allows you to write SQL queries against data dictionary for partition
maintenan...
Acum 4 ore
Niciun comentariu:
Trimiteți un comentariu