SQL>
SQL> SELECT owner, object_name, object_type, TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi') last_ddl_time
2 FROM dba_objects
3 where rownum<50;
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
OBJECT_TYPE LAST_DDL_TIME
------------------- -----------------
SYS
ICOL$
TABLE 07-feb-2006 22:38
SYS
I_USER1
INDEX 07-feb-2006 22:10
SYS
CON$
TABLE 07-feb-2006 22:38
SYS
UNDO$
TABLE 07-feb-2006 22:10
SYS
C_COBJ#
CLUSTER 07-feb-2006 22:10
SYS
I_OBJ#
INDEX 07-feb-2006 22:10
SYS
PROXY_ROLE_DATA$
TABLE 07-feb-2006 22:10
SYS
I_IND1
INDEX 07-feb-2006 22:10
SYS
I_CDEF2
INDEX 07-feb-2006 22:10
SYS
I_PROXY_ROLE_DATA$_1
INDEX 07-feb-2006 22:10
SYS
FILE$
TABLE 07-feb-2006 22:10
SYS
UET$
TABLE 07-feb-2006 22:10
SYS
I_FILE#_BLOCK#
INDEX 07-feb-2006 22:10
SYS
I_FILE1
INDEX 07-feb-2006 22:10
SYS
I_CON1
INDEX 07-feb-2006 22:10
SYS
I_OBJ3
INDEX 07-feb-2006 22:10
SYS
I_TS#
INDEX 07-feb-2006 22:10
SYS
I_CDEF4
INDEX 07-feb-2006 22:10
SYS
IND$
TABLE 07-feb-2006 22:38
SYS
SEG$
TABLE 07-feb-2006 22:10
SYS
C_TS#
CLUSTER 07-feb-2006 22:10
SYS
I_FILE2
INDEX 07-feb-2006 22:10
SYS
COL$
TABLE 07-feb-2006 22:38
SYS
I_TS1
INDEX 07-feb-2006 22:10
SYS
I_UNDO2
INDEX 07-feb-2006 22:10
SYS
CLU$
TABLE 07-feb-2006 22:10
SYS
PROXY_DATA$
TABLE 07-feb-2006 22:10
SYS
I_PROXY_DATA$
INDEX 07-feb-2006 22:10
SYS
I_OBJ1
INDEX 07-feb-2006 22:10
SYS
I_COL2
INDEX 07-feb-2006 22:10
SYS
I_OBJ2
INDEX 07-feb-2006 22:10
SYS
I_CCOL1
INDEX 07-feb-2006 22:10
SYS
TS$
TABLE 07-feb-2006 22:38
SYS
C_FILE#_BLOCK#
CLUSTER 07-feb-2006 22:10
SYS
C_USER#
CLUSTER 07-feb-2006 22:10
SYS
I_UNDO1
INDEX 07-feb-2006 22:10
SYS
BOOTSTRAP$
TABLE 07-feb-2006 22:10
SYS
FET$
TABLE 07-feb-2006 22:10
SYS
I_TAB1
INDEX 07-feb-2006 22:10
SYS
CCOL$
TABLE 07-feb-2006 22:38
SYS
USER$
TABLE 07-feb-2006 22:52
SYS
I_CON2
INDEX 07-feb-2006 22:10
SYS
I_COBJ#
INDEX 07-feb-2006 22:10
SYS
OBJ$
TABLE 07-feb-2006 22:52
SYS
I_COL3
INDEX 07-feb-2006 22:10
SYS
C_OBJ#
CLUSTER 07-feb-2006 22:10
SYS
TAB$
TABLE 07-feb-2006 22:38
SYS
CDEF$
TABLE 07-feb-2006 22:38
SYS
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
OBJECT_TYPE LAST_DDL_TIME
------------------- -----------------
I_CDEF1
INDEX 07-feb-2006 22:10
49 rows selected.
SQL>