Re: Original Database Creation Date

After some more digging:
 please take care with this date: if the database was "created" from a template, I'd expect this date reflects the creation of the template, not your DB.
But when going to (pre) 7, I doubt templates were used in those days.

2016-11-27 19:41 GMT+01:00 Jithin Sarath <jithinsarath_at_gmail.com>:

> Martin, that's interesting. I'll give it a shot
>
> Thanks!! J
>
> On 28-Nov-2016 00:05, "Martin Berger" <martin.a.berger_at_gmail.com> wrote:
>
>> Jithin,
>>
>> my next try would be a block dump of 1st block from SYSTEM tablespace.
>> There you should find a line "Creation Checkpointed at scn"
>> Unfortunately I don't know when this was introduced and if it was ever
>> changed during migrations.
>>
>> Martin
>>
>> 2016-11-27 19:24 GMT+01:00 Jithin Sarath <jithinsarath_at_gmail.com>:
>>
>>> Thanks Martin. This is definitely 7 or pre 7, so the view is not of much
>>> use for this purposes.
>>>
>>> I have had some luck depending on the application that uses the DB.
>>> Some, like Oracle DB may have dates and data which are never archived
>>>
>>> On 27-Nov-2016 23:51, "Martin Berger" <martin.a.berger_at_gmail.com> wrote:
>>>
>>>> Jithin,
>>>>
>>>> you can try DBA_FEATURE_USAGE_STATISTICS. It should be correct within 1
>>>> week.
>>>> (given the assumption it was active for 1 week after the creation).
>>>> Unfortunately this view was first introduced in 10.1 - and "early
>>>> 2000s" can mean 7.3.x as well, So it will not provide the full picture.
>>>>
>>>> It might be possible to identify the initial version based on some
>>>> leftover structures in data dictionary, but I'm not sure if the real
>>>> creation date is stored somewhere internal.
>>>>
>>>> hth
>>>> Martin
>>>>
>>>>

--
http://www.freelists.org/webpage/oracle-l