Object Create Date

Hello,

Which data dictionary I have to query to determine the object creation date..

F.ex I would like to find out on which date table or Index has been created..

Thanks

Sameer

Re: Object Create Date

Sameer Deshpande wrote:

> Hello,
>
> Which data dictionary I have to query to determine the object creation date..
>
> F.ex I would like to find out on which date table or Index has been created..

You can't.

Regards
Gaeatano Mendola

Re: Object Create Date

hi,

Gaetano Mendola wrote, On 7/26/2004 01:35:

> Sameer Deshpande wrote:
>
>> Hello,
>>
>> Which data dictionary I have to query to determine the object creation date..
>>
>> F.ex I would like to find out on which date table or Index has been created..
>
> You can't.

he can :) grab the object's OID from system tables and check the
corresponding file's create date.

C.