R12.2 : custom triggers on edition tables
Hello ,
We upgraded to R12.2.8 from 11i during the weekend. We are need to replace a trigger and it is failing with
ORA-04095: trigger 'LASERFICHE_AI_TRG' already exists on another table, cannot
replace it
The command is CREATE OR REPLACE TRIGGER LASERFICHE.LASERFICHE_AI_TRG .. BEFORE INSERT ON LASERFICHE.APX_LASERFICHE_STAGING
in DBA_Triggers , the table is editoned views.
1 select table_name, trigger_name from dba_triggers
2* where trigger_name = 'LASERFICHE_AI_TRG'
SQL> /
TABLE_NAME
--------------------------------------------------------------------------------
TRIGGER_NAME
--------------------------------------------------------------------------------
APX_LASERFICHE_STAGING#
LASERFICHE_AI_TRG
question is should we replace the trigger in editon views or should we drop and recreate the trigger on table.