Sometimes , there could be also a logical corruption inside an oracle table , which could lead to this error message .
In our case, the corruption was identified by applying length(affected_column) . The result was -1 for a row, which signifies a logical corruption .
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 o săptămână
Niciun comentariu:
Trimiteți un comentariu