Database Administration (MOSC)

MOSC Banner

Strange case of ORA-04095

edited Dec 29, 2014 10:01AM in Database Administration (MOSC) 3 commentsAnswered

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".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center