Re: Duplicating database (Unix to Win NT)

Hmm, never heard of a development environment that can't be shutdown before! ;)

If there are people using the database, then you can only take a copy of the database at a point in time, You can't capture the work that is still being done. To do this, you'd need to do a full export, CONSISTENT=Y if you're worried about consistency, and import the data back into the 8.1.7 database, provided it's had the relevant catexp* scripts run.

Additions and corrections welcome.

--
Regards

Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA


"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

>

>

>

>