SELECT *
FROM user_objects
WHERE status = 'INVALID'

Connect time(ms): 63

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 03:43:48.0|2006-10-28:03:43:42|INVALID|N|N|N
EPMFTVALIDATORPK||11324||PACKAGE BODY|2006-10-27 00:59:10.0|2006-10-28 03:43:48.0|2006-10-28:03:43:42|INVALID|N|N|N
EPMSUPPORTINGDATAPK||11298||PACKAGE|2006-10-27 00:59:03.0|2006-10-28 03:43:48.0|2006-10-28:03:43:48|INVALID|N|N|N
EPMSUPPORTINGDATAPK||11303||PACKAGE BODY|2006-10-27 00:59:05.0|2006-10-28 03:43:48.0|2006-10-28:03:43:48|INVALID|N|N|N
EPM_FAMILY_TABLE_UTILS||11341||PACKAGE|2006-10-27 00:59:15.0|2006-10-28 04:05:06.0|2006-10-28:04:05:06|INVALID|N|N|N
EPM_FAMILY_TABLE_UTILS||11342||PACKAGE BODY|2006-10-27 00:59:15.0|2006-10-28 04:05:06.0|2006-10-28:04:05:06|INVALID|N|N|N
TABLE_OF_TABLE_OF_NUMBER||11316||TYPE|2006-10-27 00:59:09.0|2006-10-28 03:43:42.0|2006-10-28:03:43:42|INVALID|N|N|N

