complete oracle replication example?

[abc_18]

Is there a complete oracle replication example
out there somewhere? I'm just looking for a tiny example, but one that shows *all* the steps. And hopefully one that's been debugged (ie, no typos, etc).

Ideally, I'd like to find an example of each
flavor of replication, ie:
a) streams replication, and
b) "advanced" replication

This is for a Oracle 10gR2 configuration, on
HP-UX 11.11

Thanks in advance!

[Yogeeraj_1 · Accepted solution]

hi abc,

unfortunately, i can only direct you to the Oracle documentations.

see:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repoverview.htm#sthref13

http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repoverview.htm#REPLN001

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14227/raroverview.htm#sthref12


hope this helps!
kind regards
yogeeraj

[Yogeeraj_1]

hi again,

for streams replication, see:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14228/gen_rep.htm#BABFIDJE


hope this helps too!

kind regards
yogeeraj

[Eric Antunes]

Hi abc,

Here are some docs from Metalink:

Note 298877.1 (10g Streams Recommended Configuration), which also points you to other notes;

Note 150904.1 (Oracle9i Replication New Feature, Master Replication of User-Defined Types);

Note 250413.1 (Replication Setup; Backup and Recovery; Adding New Node to DRG);

...

Doing an Advanced search in metalink with the the following 2 words: "replication" and "example", you will get much more.

Best Regards,

Eric Antunes

[Eric Antunes]

Some more:

Note 138181.1 (Designing for Survivability - Advanced Replication : A Practical Example);

Note 150905.1 (Oracle9i Materialized View New Feature, Replication of User-Defined Types);

Note 313478.1 (Performing Manual DDL in a Streams Environment);

...

Best Regards,

Eric Antunes