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,
Quote:
>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