Re: Upgrade 8.1.6 -> 9.2 via exp/imp

(c) ... Find out what these schemas are for and remove one you don't need.

          You can even post what schemas you are unsure of, here and maybe we
           might recognize some default users.

Anrag

"Walt" <walt_at_boatnerd.com> wrote in message news:3FA16744.3C204848_at_boatnerd.com...
>
> 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.
>
>
> --
> //-Walt
> //
> //
Received on Thu Oct 30 2003 - 20:32:08 CST