<div>
What is the purpose for the synchronization?<br />
<br />
I assume you want one-way. &nbsp;If two way I suggest Oracle Streams.<br />
<br />
For one-way I would look at dataguard and a standby database. &nbsp;There are limitations on the availability of the receiving database.<br />
<br />
There is also export/import. &nbsp;Possibly log miner.<br />
<br />
Until we know the requirements it will be hard to provide the best advice.
</div>


<div>
dear sir <br />
<br />
thank your reference response<br />
<br />
oracle database replication any facilty or tools inside oracle or outside available.<br />
<br />
i understand the dataguard stanby<br />
<br />
any possible feature, i heard name of table transport feature in oracle<br />
<br />
but in all honesty no idea how where to work around get helpline<br />
<br />
kind regards<br />
tmsa
</div>


<div>
dear support<br />
<br />
thank you<br />
<br />
can we find some help line of tablespace transport or table transport from 1 machine to another same env, same rhel 5.8, oracle 10gr2 also same.<br />
<br />
any possible option<br />
<br />
kind regard
</div>


<div>
&gt;&gt;can we find some help line of tablespace transport <br />
<br />
I'll defer to the online docs for information on transportable tablespaces:<br />
<a href="http://docs.oracle.com/cd/B19306_01/server.102/b14231/tspaces.htm#i1007169" rel="ugc">http://docs.oracle.com/cd/B19306_01/server.102/b14231/tspaces.htm#i1007169</a><br />
<br />
&gt;&gt;oracle database replication any facilty or tools inside oracle or outside available.<br />
<br />
Oracle Streams Replication is what I was suggesting. &nbsp;There is also an older Replication method available but I prefer Streams.
</div>


<div>
<div class="content wysiwyg-content">
dear sir,<br />
<br />
can some one assist, we are using rhel 5.8 64 bits with oracle 10gr2<br />
<br />
we want send tables data daily basis realtime or by schedule to another pc machine which has similar to the above env, but different hostname,ip but oracle instance db name is same, majorly they are inside 2 oracle schemas say operation schema and gl schemas consist of tables.<br />
<br />
<br />
any technical term use for it advise<br />
<br />
kind regards<br />
tmsa
</div>
</div>


dear sir,

can some one assist, we are using rhel 5.8 64 bits with oracle 10gr2

we want send tables data daily basis realtime or by schedule to another pc machine which has similar to the above env, but different hostname,ip but oracle instance db name is same, majorly they are inside 2 oracle schemas say operation schema and gl schemas consist of tables.


any technical term use for it advise

kind regards
tmsa

oracle 10gr2 tables syncing

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.