SQL>
SQL> create table bar ( n number );
Table created.
SQL>
SQL> alter table bar add d date;
Table altered.
SQL>
SQL> select object_type, status
2 from user_objects
3 where object_name = 'SHIELD'
4 /
OBJECT_TYPE STATUS
------------------- -------
PACKAGE VALID
PACKAGE BODY VALID
SQL>
SQL> drop table bar;
Table dropped.
SQL>