PDB startup trigger not firing
Hi all,
It seems that the PDB startup trigger is not firing:
I want to use a trigger that fires when the PDB is opened.
alter session set container = PDB1;
create table sys_trigger_debug ( a timestamp, b varchar2(2000));
CREATE OR REPLACE NONEDITIONABLE TRIGGER "SYS"."PDB_START_TRIGGER" AFTER STARTUP ON PLUGGABLE DATABASE
DECLARE
V_STATUS VARCHAR2(12);
BEGIN
SELECT STATUS INTO V_STATUS FROM V$INSTANCE;
insert into sys_trigger_debug values (systimestamp,'V_STATUS:'||V_STATUS||',CON_NAME:'||SYS_CONTEXT('USERENV','CON_NAME'));
END;
/
Trigger created.
SQL> select status from dba_objects where object_name = 'PDB_START_TRIGGER';