Oracle Replication

15 pts.
Tags:
Oracle
Oracle 10g
Oracle 10g Express
Oracle 10g replication
Oracle replication
how to configure basic replication in oracle 10g express

Answer Wiki

Thanks. We'll let you know when a new response is added.

Basic replication is implemented through materialized views, and I think Oracle XE (express edition) supports read-only materialized views only (not updateable).

There is not much documentation about “basic” replication specifically, but I guess any materialized views documentation could provide some help.

Here are a couple of links you might find interesting:

<a href=”http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14223/basicmv.htm#g1028195″>Basic Materialized Views</a>
<a href=”http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6002.htm#i2063793″>CREATE MATERIALIZED VIEW </a>

————————————-

Well, this is not as detailed as a step by step guide, but I hope this can clarify things a little.

- First, you need a database link between the 2 databases (<a href=”http://searchoracle.techtarget.com/tip/0,289483,sid41_gci1263933,00.html”>How to create a database link in Oracle</a>)
- grant the “create materialized view ” privilege to the user.
- Identify the tables you want to be replicated
- Identify the way you want your MV to be refreshed.
- Create the materialized views

Information about the last 2 actions can be found on the above links.

A simple example on creating a MV could be (using the defaults for the many available parameters):

<pre>CREATE MATERIALIZED VIEW emp
as
SELECT * FROM emp@your_dblink;</pre>

Hope this helps.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jothi
    read the link but i need step by step guide for basic replication from oracle in linux and another instance in windows.since, iam new to oracle i need this
    15 pointsBadges:
    report
  • Chussi
    Can someone provide me a kind of a step by step guide to setup basic replication on standard edition. I donĀ“t have a clue how to start.... Thanks a lot
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following