topic complete oracle replication example? in Operating System - HP-UX

complete oracle replication example?

abc_18 — Fri, 03 Mar 2006 21:28:03 GMT

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!

Re: complete oracle replication example?

Yogeeraj_1 — Mon, 06 Mar 2006 04:05:50 GMT

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

Re: complete oracle replication example?

Yogeeraj_1 — Mon, 06 Mar 2006 04:22:21 GMT

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

Re: complete oracle replication example?

Eric Antunes — Mon, 06 Mar 2006 05:00:56 GMT

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

Re: complete oracle replication example?

Eric Antunes — Mon, 06 Mar 2006 05:06:02 GMT

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