--------------------------------------------------------------------------

Ari,

How do you determine when an object was created withing the databse, without
auditing the database?

Marin
--------------------------------------------------------------------------
To: Marin Komadina 
Marin,

To answer your question, YES you can see the date and time that an index
(or table or other object) was created.

If you issue:

SELECT OWNER, OBJECT_NAME, CREATED, LAST_DDL_TIME
FROM DBA_OBJECTS
WHERE OBJECT_NAME = 'enter_object_name_here';

then you will see when the object was created along with the timestamp for
the last modification of the object (including GRANT and REVOKE commands).

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 345+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://www.arikaplan.com                          <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page