Re: How to Move a Database

Assuming further that the tablespaces and users are the same, then export the desired tables, etc ( or the whole database ) at home and import it at work...Remember that you will be replacing tables, etc when you do this, not updating them....

( Also, I hope it is not a very large database, or you have a large capacity removable storage device )

Hope it helps,

"Doug Stone" <dstone_at_res-q.com> wrote:

>Often I will perform NT4 / Oracle 8 at home.
>
>When I return to the office, I would like to just copy the Oracle DB from my
>NT4 workstation to our office NT4 Server based Oracle Server.
>
>Is there a way for me to just copy the db's files? I'm assuming that SID's
>with the same name have already been created on both the workstation and
>server Oracle.
>
>Thank you,
>Doug
>
>

To reply please remove the 'nospam' part of the address Received on Fri Dec 18 1998 - 13:03:13 CST