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
Configuring a RAC Service tied to a PDB and specific Instance
-
I have created a new *Video demonstrating how you can add new Services to
an existing database*. In RAC, you can choose to have the Service running
on ...
Acum 6 zile
Niciun comentariu:
Trimiteți un comentariu