Re: Create time of a next extent

Marc Zwygart wrote:
>
> Hi
>
> I am using ORACLE7.1.6 on an UNiX-System.
>
> Does anyone know, how I can get the create-time of a next extent when a
> table or an index allocate the space in its tablespace?
>

I don't think such a time-stamp is recorded anywhere in the data dictionary (somebody please correct me if I'm wrong). But you could build your own extent_creation_time_log table and write appropriate database trigger on USER_EXTENTS (DBA_EXTENTS) table.

Jure

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================