Re: Upgrade 8.1.6 -> 9.2 via exp/imp

For a production database is preferable IMHO to NOT have the example schemas & other schemas relating to unused Oracle options (OLAP, Spatial, Data Mining etc.).

I do however leave the features that Oracle now considers 'standard' (JVM, Intermedia, Text and XML DB), though until I find a need to use it   I do disable the XML DB protocols as recommended in an Oracle Security alert.

The downside is that there are no 'canned' data files for this so all the dictionary & JVM build scripts get run which does take a while. On the other hand, this is a good way to prove your Oracle installation.

KJP Walt wrote:

> I'm upgrading a production Oracle database from 8.1.6 on WinNT to 9.2 on
> W2k.
>
> The upgrade path I have chosen is to migrate using Export/Import (this
> is so that I can do multiple dry runs without having to take the current
> production system off line.)
>
> I've installed 9.2 on the new box and used the database configuration
> assistant to get it up and running. So far, so good. But I notice that
> I've got a couple of dozen users/schemas that don't appear to be
> necessary. Most are locked. Before I do a full import from the current
> box,
>
> Should I
>
> a) drop all users and tablespaces except for sys and system?
>
> b) leave things as they are and import over the top of what's already
> there?
>
> c) attempt to figure out what each of these schemas are for and remove
> the cruft?
>
> d) start over with a new database creation script that does a cleaner
> install?
>
> Thanks.
>
>
Received on Thu Oct 30 2003 - 19:52:46 CST