Would 2004 be around the date of the migration from Unix to Windows. Pretty
much the only option then would have been export/import.
On Mon, Nov 28, 2016 at 6:00 AM, Jithin Sarath <jithinsarath@xxxxxxxxx>
wrote:
Hmm.. the block dump of the first block shows a date from mid 2004, and so
does the DBA_OBJECTS.CREATED.
I'm now trying to figure out what happened in 2004 and wondering how would
one get information prior to that
Thanks, J
On 28 November 2016 at 00:23, Martin Berger <martin.a.berger@xxxxxxxxx>
wrote:
;-)
last thing (sorry I come up with pieces, not a full picture at once)
what's about DBA_OBJECTS.CREATED ?
At least you can use it to crosscheck all other observations ...
enjoy
Martin
2016-11-27 19:51 GMT+01:00 Jithin Sarath <jithinsarath@xxxxxxxxx>:
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@xxxxxxxxx> 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@xxxxxxxxx>:
Martin, that's interesting. I'll give it a shot
Thanks!! J
On 28-Nov-2016 00:05, "Martin Berger" <martin.a.berger@xxxxxxxxx>
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@xxxxxxxxx>:
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@xxxxxxxxx>
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