Originally posted by grjohnson:
Yeah but was it already rebuild today? Stick a TO_CHAR around the last_ddl_time
No Johnson. I guess its a different version of Oracle we are using. You are on 8i, I guess while I am ancient(8).

SQL> select object_name, object_type, to_char(last_ddl_time, 'DD/MM/YYYY HH24:MI
:SS')
fr 2 om user_objects where object_name= 'MCF_EXCEPTION_LOOKUP_1';

OBJECT_NAME OBJECT_TYPE TO_CHAR(LAST_DDL_TI
------------------------------ --------------- -------------------
MCF_EXCEPTION_LOOKUP_1 INDEX 21/02/2003 16:18:30

SQL> alter index MCF_EXCEPTION_LOOKUP_1 rebuild;

Index altered.

SQL> select object_name, object_type, to_char(last_ddl_time, 'DD/MM/YYYY HH24:M
I:SS') from user_objects where object_name= 'MCF_EXCEPTION_LOOKUP_1';

OBJECT_NAME OBJECT_TYPE TO_CHAR(LAST_DDL_TI
------------------------------ --------------- -------------------
MCF_EXCEPTION_LOOKUP_1 INDEX 21/02/2003 16:18:30


Raminder