MYDBA@orcl > select count(*) from dba_triggers where owner = 'SYS';

  COUNT(*)
----------
        13

1 row selected.

MYDBA@orcl > select trigger_name from dba_triggers where owner = 'SYS';

TRIGGER_NAME
------------------------------
AW_DROP_TRG
NO_VM_DROP
NO_VM_DROP_A
NO_VM_CREATE
NO_VM_ALTER
AURORA$SERVER$STARTUP
AURORA$SERVER$SHUTDOWN
CDC_ALTER_CTABLE_BEFORE
CDC_CREATE_CTABLE_AFTER
CDC_CREATE_CTABLE_BEFORE
CDC_DROP_CTABLE_BEFORE
OLAPISTARTUPTRIGGER
OLAPISHUTDOWNTRIGGER

13 rows selected.

MYDBA@orcl >

--
-- From Source database.
dbadmin@dubbel_primary > SELECT TRIGGER_NAME,OWNER from dba_triggers;

TRIGGER_NAME                   OWNER
------------------------------ ------------------------------
DEF$_PROPAGATOR_TRIG           SYSTEM
REPCATLOGTRIG                  SYSTEM
bi_BASE_DATA1                  ANTIBODY
MYTRIGGER                      DBADMIN
AW_DROP_TRG                    SYS
NO_VM_DROP                     SYS
NO_VM_DROP_A                   SYS
NO_VM_CREATE                   SYS
NO_VM_ALTER                    SYS

9 rows selected.

--
-- Just a quick grep through the log file.
-- An attempt to recreate all triggers execpt the ones
-- owned by SYS is shown
-- DBADMIN and ANTIBODY are database users.
--
oracle@dubbel:~> cat full.log | grep "CREATE TRIGGER"
 "GRANT CREATE TRIGGER TO "RECOVERY_CATALOG_OWNER""
 "CREATE TRIGGER "SYSTEM".def$_propagator_trig"
 "CREATE TRIGGER "SYSTEM".repcatlogtrig"
 "CREATE TRIGGER "DBADMIN".mytrigger"
 "CREATE TRIGGER "ANTIBODY"."bi_BASE_DATA1" "