How to Move a Database 
Author Message
 How to Move a Database
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



Tue, 05 Jun 2001 03:00:00 GMT
 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,

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


Tue, 05 Jun 2001 03:00:00 GMT
 How to Move a Database
TurkBear:

Hi.  Thanks for the feedback.

Would you ever just copy database (ctl, usr, init, log, etc.) files from one
computer to another?

Doug



Thu, 07 Jun 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL 7.0 - Moving a database from one machine to another

2. Steps to move/copy database

3. How do i move a database?

4. How to move replicated database to another drive

5. How I can move 2 databases(replicated ) to other computer

6. VERY URGENT !!! Move Subscription database

7. How do I move a Database

8. Need to move MSSQL Database

9. How Do I Move A Database?

10. Need to move entire database sql7

11. question I needd to do a restore with move for databases with filegroups - Synacx Question

12. Can you move a database from 7.0 to 6.5


 
Powered by phpBB® Forum Software