Answer:

There is a field name created in the dba_objects view and gives that info.

CJ

SQLWKS> desc all_objects
Column Name                    Null?    Type
------------------------------ -------- ----
OWNER                          NOT NULL VARCHAR2(30)
OBJECT_NAME                    NOT NULL VARCHAR2(30)
OBJECT_ID                      NOT NULL NUMBER
OBJECT_TYPE                             VARCHAR2(12)
CREATED                        NOT NULL DATE
LAST_DDL_TIME                  NOT NULL DATE
TIMESTAMP                               VARCHAR2(75)
STATUS                                  VARCHAR2(7)
 
 

Franz Mueller wrote in message <[email protected]>...
>Hi,
>
>is there a way to know the date of creation of a new index?
>
>Franz