Oracle 10g upgrade with Workspace Manager
Date: Fri, 16 May 2008 09:47:27 -0400
One of our last databases to upgrade to 10G makes extensive use of Oracle Workspace Manager. At 9i OWM does not support schema exports. Most of our other databases were upgraded with dbua. There are some issues with OWM and its TIMESTAMP WITH TIME ZONE that must be treated manually after dbua in this instance. For that, and a mess of other reasons, I'd like to create a fresh 10G database, a full database export from 9i to the new 10g. Of course, we're going to try this on a staging machine first, but has anyone else done this already? My concern is the differences in how OWM is configured, with a lot stuff in the SYS schema in 9i which moves to WMSYS is 10G. And probably other things I'm forgetting. All in all, most problems in this databases are because of OWM and there is usually little information about it because it's not widely used. I was to avoid as much heartache as possible.
Oracle DBA Supervisor
Information Resources Department
Application Systems Section
Southwest Florida Water Management District 352-796-7211 x4033
Good judgement comes from experience,
and a lot of that comes from bad judgement.
IMPORTANT NOTICE: All E-mail sent to or from this address are public record and archived. The Southwest Florida Water Management District does not allow use of District equipment and E-mail facilities for non-District business purposes.
http://www.freelists.org/webpage/oracle-l Received on Fri May 16 2008 - 08:47:27 CDT