RE: 10g upgrade survey
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, oracledba.williams@xxxxxxxxx, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Mar 2007 11:50:07 -0700
Yes. #2 supports exp/imp; We had to go that way since we had dictionary
corruption. I am not all that happy with making a copy of dba_objects. That
leaves it with #1.
Another aspect that comes to my mind is that if you are creating a brand new
10g database (say) and exp/imp data from 9i or 8i or 8 which had Dict.Mgnd
tablespace, then the imported data will be sitting in LMT and this would not be
exactly be the same as what it was earlier. With upgrade , your tablespace
would still be DMT. If it is production i would prefer to go with Upgrade. I
agree it is round about way first upgrading to 8.1.7.4 or any other higher
(supported) patch level and then upgrading to 10g. That can introduce errors as
well. Just my opinion.
Regards
Govindan
On Tue, 20 Mar 2007 10:56:04 -0700, "Allen, Brandon"
<Brandon.Allen@xxxxxxxxxxx> said:
Not sure what you mean by #2 - it sounds like an argument for using exp/imp as
you have it phrased there.
If you really care about retaining object creation times, I'd recommend logging
them somewhere else than in dba_objects because they can get updated there at
unexpected times. You could easily do a "create table object_creation_dates as
select owner, object_id, object_name, created from dba_objects" and that would
take care of that problem for you.
Regards,
Brandon
____________________________________________________________
From: GovindanK [mailto:gkatteri@xxxxxxxxxxx]
Sent: Tuesday, March 20, 2007 10:52 AM
To: Allen, Brandon; oracledba.williams@xxxxxxxxx; Oracle Discussion List
Subject: RE: 10g upgrade survey
I see three reasons against going for exp/imp:
1. Minimal downtime
2. System Tablespace / Data Dictionary corrupted but i am able to export all
user/data schema
3. I would need to retain the timestamp,create date as per dba_objects
HTH
GovindanK
Other related posts:
