Re: Original Database Creation Date

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
>>
>>

-- 
Martin Berger         +43 660 2978929 <+436602978929>
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com

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