Re: Copy DATABASE dir to another Oracle installation?

From: S. P. Pohilko <pohilko_at_prodigy.net>
Date: Tue, 19 Jan 1999 20:25:55 -0600
Message-ID: <36A53EB3.65103866@prodigy.net>

Adrian Harrison wrote:

> We have 2 installations of Personal Oracle on NT Server 4 & Win 98!
>
> What I would like to do is to copy all the data from one to the other so that any test data we setup
> on one hasn't got to be input on the other!
>
> On one PC its installed in "I:\orant" & the other "H:\Ora95"
>
> Can I just copy the "DATABASE" directory across?

The simplest way is to use export/import (in the User mode). This will copy all the objects in the User schema.

S.Peter Pohilko Received on Tue Jan 19 1999 - 20:25:55 CST