Strange case of ORA-04095
Hello, we are facing a strange case of ORA-04095 error. Tried to find some solution googling around and also on metalink but could not find a thread that meets exactly our scenario. All scenarios we found describes a situation where the trigger already exists in the same schema but it is not our case ... the trigger creation is conflicting with a trigger of the same name that only exists in another schema!!!
Basically we are having this error while creating 5 triggers but we do not have triggers with the mentioned names on the schema (let´s say "schema B", which is a clone of another schema that already exists in the same instance) just on the original schema ("schema A") in the same instance! More strange is that when we query USER_TRIGGERS on "schema B" it is listed the triggers of "schema A".