SQL> select object_name,status from all_objects where object_type='TRIGGER';OBJECT_NAME STATUS
------------------------------ -------
DEF$_PROPAGATOR_TRIG VALID
REPCATLOGTRIG VALID
PERMTRIG VALID
TEST INVALID
TEST_NEW1 INVALID
TEST_NEW11 INVALID
SDO_DROP_USER VALID
SDO_GEOM_TRIG_DEL1 VALID
SDO_GEOM_TRIG_INS1 VALID
SDO_GEOM_TRIG_UPD1 VALID10 rows selected.
------------------------------ -------
DEF$_PROPAGATOR_TRIG VALID
REPCATLOGTRIG VALID
PERMTRIG VALID
TEST INVALID
TEST_NEW1 INVALID
TEST_NEW11 INVALID
SDO_DROP_USER VALID
SDO_GEOM_TRIG_DEL1 VALID
SDO_GEOM_TRIG_INS1 VALID
SDO_GEOM_TRIG_UPD1 VALID10 rows selected.
Errors for TRIGGER TEST:LINE/COL ERROR
-------- -----------------------------------------------------------------
2/4 PL/SQL: SQL Statement ignored
2/16 PLS-00201: identifier 'TEST.NEXTVAL' must be declared
SQL>