Re: Original Database Creation Date

Yeah, I'm pretty sure there were no templates back then. Will do this first thing in the morning tomorrow and see how this goes.

On 28-Nov-2016 00:18, "Martin Berger" <martin.a.berger_at_gmail.com> wrote:

> 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