DROP A TRIGGER NEEDS TOO MUCH TIME
442177Aug 9 2005 — edited Aug 9 2005HELLO EVERYBODY :
I HAVE THE FOLLOWING PROBLEM , I HAVE WRITE A TRIGGER AND WHEN I TRY TO DO EXECUTE IT , I TAKES TOO MUCH TIME ,( I HAVE WAIT FOR HALF AN HOUR BEFORE STOP IT ) , I THOUGH THAT MY TRIGGER WAS WRONG SO I DECIDED TO DISABLE , THE RESULT WAS THAT THE SAME THE OPERATION TAKES A LOT OF TIME , AND I STOP IT AFTER 30 MINUTES WITHOUT DO NOTHING , FINALLY I HAVE TRY TO DROP THE TRIGGER USING SQLPLUS AND THE FOLLOWING SENTENCE :"DROP TRIGGER ADMIN.VEHICULOS;" AND I HAVE THE SAME PROBLEM AS THE OTHER TIMES. I'M USING ORACLE 10g OVER WINDOWS 2003 SERVER WITH SERVICE PACK 1. THANKS IN ADVANCE .