SELECT * FROM user_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): 15

OBJECT_NAME|SUBOBJECT_NAME|OBJECT_ID|DATA_OBJECT_ID|OBJECT_TYPE|CREATED|LAST_DDL_TIME|TIMESTAMP|STATUS|TEMPORARY|GENERATED|SECONDARY
EPMFTVALIDATORPK||11323||PACKAGE|2006-10-27 00:59:10.0|2006-10-28 13:26:06.0|2006-10-28:13:26:00|INVALID|N|N|N
EPMFTVALIDATORPK||11324||PACKAGE BODY|2006-10-27 00:59:10.0|2006-10-28 13:26:06.0|2006-10-28:13:26:01|INVALID|N|N|N
EPMSUPPORTINGDATAPK||11298||PACKAGE|2006-10-27 00:59:03.0|2006-10-28 13:26:07.0|2006-10-28:13:26:06|INVALID|N|N|N
EPMSUPPORTINGDATAPK||11303||PACKAGE BODY|2006-10-27 00:59:05.0|2006-10-28 13:26:07.0|2006-10-28:13:26:06|INVALID|N|N|N
EPM_FAMILY_TABLE_UTILS||11341||PACKAGE|2006-10-27 00:59:15.0|2006-10-28 13:26:07.0|2006-10-28:13:26:04|INVALID|N|N|N
EPM_FAMILY_TABLE_UTILS||11342||PACKAGE BODY|2006-10-27 00:59:15.0|2006-10-28 13:26:07.0|2006-10-28:13:26:04|INVALID|N|N|N
TABLE_OF_TABLE_OF_NUMBER||11316||TYPE|2006-10-27 00:59:09.0|2006-10-28 13:26:00.0|2006-10-28:13:26:00|INVALID|N|N|N

