For some hours ago I’ve canceled an DROP INDEX operation. Toad become non responsive, and I had to “kill” it from Windows Task Manager. I started Toad again, and I executed DROP INDEX myIndex FORCE. This worked.
But I have a package containing several procedures related to the table whose index I dropped. Now, when I compile this package, Toad becomes not responsive.
It seems that something has been locked (?). Has anybody some tips?
Thank you in advance.