Re: Migrating an Oracle Instance from Sun to NT

Hi,

Migrating is not a problem at all. You just install Oracle and recreate your instance on NT by running
your database and data tables creation scripts. After that you export the data from SUN and import it into
the empty NT database. Do not create the indexes beforehand. It is much slower for large tables.
When you export the data make shure that COMPRESS=NO (exp .....COMPRESS=NO ....) from the command file or the
better way is to create a parameter file. Compress when enabled is trying to compress fragmented segments into single extents. That affects the storage clauses that will be stored in the export file and later on you could have problems with starage parameters when the data is imported in the new unpopulated database.

Regards,

Alex

"Bill Hamlin" <whamlin1_at_rochester.rr.com> wrote in message news:cJFk5.2960$0E5.80715_at_typhoon.nyroc.rr.com...
> Anyone have any experience in migrating an Oracle instance from Sun to NT?
> I have a client who is contemplating this, and would be interested in
 advice
> from anyone who's actually done this sort of migration.
>
> TIA
>
> Bill
>
>
>
Received on Fri Aug 11 2000 - 00:00:00 CDT