SQL> select o.object_name, o.object_type from user_objects o
   2   where o.status = 'INVALID';
 
OBJECT_NAME                                                                      OBJECT_TYPE
-------------------------------------------------------------------------------- -------------------
BIN$ 41 /N7JXtR3ec/+tq7/zp0w==$ 0                                                    TRIGGER
 
SQL> 

SQL> select * from user_recyclebin;
 
OBJECT_NAME                    ORIGINAL_NAME                    OPERATION TYPE                      TS_NAME                        CREATETIME          DROPTIME               DROPSCN PARTITION_NAME                   CAN_UNDROP CAN_PURGE    RELATED BASE_OBJECT PURGE_OBJECT      SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------
BIN$a1RBmz/rTYSTKxCk8HhjCA==$ 0  WASTE_CONTENER                   DROP      TABLE                     USERS                           2010 - 05 - 21 : 11 : 35 : 08   2010 - 05 - 21 : 11 : 38 : 45   1109223943                                   YES        YES            200877        200877         200877            8 
BIN$wALi7qnXTNSvYSAxOXYvtA==$ 0  DB_PARAMS_ITYPE                  DROP      INDEX                     USERS                           2010 - 06 - 29 : 09 : 30 : 57   2010 - 06 - 29 : 15 : 52 : 36   1112914643                                   NO         YES            202905        202905         202909            8 
BIN$OVTHLV+qQ7ShC9PEiSktYg==$ 0  DB_PARAMS_INAME                  DROP      INDEX                     USERS                           2010 - 06 - 29 : 09 : 32 : 29   2010 - 06 - 29 : 15 : 52 : 36   1112914646                                   NO         YES            202905        202905         202910            8 
BIN$ 41 /N7JXtR3ec/+tq7/zp0w==$ 0  DB_PARAMS_TIB                    DROP      TRIGGER                                                   2010 - 06 - 29 : 09 : 29 : 41   2010 - 06 - 29 : 15 : 52 : 36   1112914649                                   NO         NO             202908        202905         202908  
BIN$601Vn1uGTOu0NbQTgEkL6A==$ 0  DB_PARAMS                        DROP      TABLE                     USERS                           2010 - 06 - 29 : 09 : 10 : 57   2010 - 06 - 29 : 15 : 52 : 36   1112914667                                   YES        YES            202905        202905         202905            8 
 
SQL>

create sequence S_TEST
minvalue  1 
start with  1 ;
/


create or replace procedure P_TEST is
i int;
begin
select S_TEST.CURRVAL into i from dual;
end P_TEST;
/

drop sequence S_TEST;

SQL> select o.object_name, o.object_type from user_objects o
   2   where o.status = 'INVALID';
 
OBJECT_NAME                                                                      OBJECT_TYPE
-------------------------------------------------------------------------------- -------------------
BIN$ 41 /N7JXtR3ec/+tq7/zp0w==$ 0                                                    TRIGGER
P_TEST                                                                           PROCEDURE
 
SQL> 

create sequence S_TEST
start with  1000 
increment by  2 ; 

BEGIN
DBMS_UTILITY.COMPILE_SCHEMA (schema => 'WMSS', compile_all => FALSE);
END;
/

SQL> 
SQL> select o.object_name, o.object_type from user_objects o
   2   where o.status = 'INVALID';
 
OBJECT_NAME                                                                      OBJECT_TYPE
-------------------------------------------------------------------------------- -------------------
BIN$ 41 /N7JXtR3ec/+tq7/zp0w==$ 0                                                    TRIGGER
 
SQL>