Oracle 10g upgrade with Workspace Manager

  • From: Sherrie.Kubis@xxxxxxxxxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • 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.

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

Other related posts: