RE: 10g upgrade survey

 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_at_OneNeck.com> 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_at_fastmail.fm] Sent: Tuesday, March 20, 2007 10:52 AM
To: Allen, Brandon; oracledba.williams_at_gmail.com; 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

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