In Toad 10, when trying to Alter Index and select monitoring (under Basic Info tab) it does not create sql to run and gives the message that script is empty when you try to click OK. If the SQL (show sql button) is reviewed, the script is actually empty when its suppose to have something like:
ALTER INDEX testshm.ABC_01
MONITORING USAGE;
This is the same issue for both enabling or disabling monitoring. Other options like parallel,etc. dont have this problem.
There are no problems with 9.7.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center