Invalid Oracle Triggers

User 8688ffe688

09-03-2007 15:16:55

Anybody see invalid oracle triggers starting with the text "BIN$" when jchem indexes are invalid ( select object_name from user_objects where object_type = 'TRIGGER' and status = 'INVALID' ). If so, how did you get drop them? Secondly, when, whey and where are these coming from?

ChemAxon aa7c50abf8

09-03-2007 17:52:38

Triggers related to tables in your recycle-bin?





Have you tried purging your recycle-bin?





P.

User 8688ffe688

09-03-2007 17:56:41

Do you know the sql call to do that?

ChemAxon aa7c50abf8

09-03-2007 17:58:43

purge recyclebin