|
|
| Re: Oracle DBA with replication [message #369040 is a reply to message #368705] |
Fri, 15 September 2000 13:06   |
Malar
Messages: 1
Registered: September 2000
|
Junior Member |
|
|
|
We have the production site and have to set up the remote replication site. We are planning to construct the remote site the very first data transfer thro' export or thro' media (CD or tape) as the database is huge. Once the database is up and running is it possible to build the relation between the 2 schemas to replicate the data.
|
|
|
|
| Re: Oracle DBA with replication [message #369041 is a reply to message #368705] |
Fri, 15 September 2000 14:06 |
Rajeeva
Messages: 20
Registered: October 1998
|
Junior Member |
|
|
All you need to do is to create the database links and implement replication. REmember after the export/backup of the primary database is taken, until the second database is populated you should not change any data in the primary DB. If this is unavoidable, populate the second database by implement replication with the COPY ROWS option.
This is a very long process and you have to take care of the Ref. Int. constraints. Also there are other ways of populating the second database. You can Ship logs to the second database as a stand by database. Then also you can copy tables and populate the second database etc.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
