select OBJECT_NAME,OWNER,OBJECT_TYPE,STATUS from dba_objects where status='INVALID'

Connect time(ms): 78

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 47

OBJECT_NAME|OWNER|OBJECT_TYPE|STATUS
EPMFTVALIDATORPK|SYSTEM|PACKAGE|INVALID
EPMFTVALIDATORPK|SYSTEM|PACKAGE BODY|INVALID
EPMSUPPORTINGDATAPK|SYSTEM|PACKAGE|INVALID
EPMSUPPORTINGDATAPK|SYSTEM|PACKAGE BODY|INVALID
EPM_FAMILY_TABLE_UTILS|SYSTEM|PACKAGE|INVALID
EPM_FAMILY_TABLE_UTILS|SYSTEM|PACKAGE BODY|INVALID
TABLE_OF_TABLE_OF_NUMBER|SYSTEM|TYPE|INVALID

