Re: Duplicating database (Unix to Win NT)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 3 Aug 2001 03:50:08 -0700
Message-ID: <a20d28ee.0108030250.18711e54@posting.google.com>

"Eileen Ong" <eileen_ong_at_abacus.com.sg> wrote in message news:<9kd32h$osd$1_at_newton.pacific.net.sg>...
> Hi,
>
> I need to duplicate the development database from the Unix platform (running
> Oracle 7.3.4.5.0) to the Win NT server (running Oracle 8.1.7). What are the
> steps that I have take, assuming that I cannot shutdown the development
> database?
>
> Thank you in advance.
>
> Cheers
> Eileen

Eileen,

This is not a duplication, but an upgrade. Also Unix and NT are not compatible, so the *only* way is: exp on Unix and imp on NT (don't forget to ftp those files binary, or you will create real havoc). That said you don't need to shut the development database, though IMO a database which can't be shut down is not a development database.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 03 2001 - 05:50:08 CDT