Update entire database [message #357846] |
Thu, 06 November 2008 22:39 |
h_jitendras
Messages: 36 Registered: October 2006
|
Member |
|
|
I am not sure if this is the right place to post the query here...
We have a 10g d/b on UNIX box at client-site and a local d/b server(OS - Windows 2003 server) at offshore.Now I have to have identical versions of the data on the UNIX box d/b and the one on windows 2003 server.
Can just exporting the data from the UNIX box d/b and copying that dump into the d/b on Windows 2003 server help me achieve this?
Also do we need to handle this differently since we are copying d/b data across diff OS?
|
|
|
|
Re: Update entire database [message #358004 is a reply to message #357846] |
Fri, 07 November 2008 12:58 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Does the destination database have data in it? If so, then you have to drop all the tables. I am hoping that you are not asking how to synch the destination databases to the source database. Talk about a headache.
|
|
|