In Oracle 9i&10G, in order to use function based indexes, you have to set :
QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
http://www.akadia.com/services/ora_function_based_index_2.html
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