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
Grid Infrastructure --- OCR and Voting Disks Location at Installation
-
In Oracle Grid Infrastructure, the OCR (Oracle Cluster Registry) and
Voting "Disks" must be on Shared Storage accessible by all the nodes of the
Cluster...
Acum 5 zile
Niciun comentariu:
Trimiteți un comentariu