Re: Replicating an entire schema ...

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Thu, 18 Sep 2003 16:30:10 GMT
Message-ID: <m4lab.10143$3%6.9895@nwrddc03.gnilink.net>

"Domenic G." <domenicg_at_hotmail.com> wrote in message news:c7e08a19.0309180731.38ecc323_at_posting.google.com...
> Folks,
>
> I've been playing around with Multi-Master Replication using the OEM
> tool -- question, is there a dbms_repcat procedure that you can call
> to replicate all the tables within a schema or must it be done table
> by table? I can't seem to find such a proc. This seems tedious if I
> have to replicate 500 tables, unless I do a SQL on SQL query to
> generate the script.
>
> Thanks in advance for all replies ...
>
> Domenic.

afaik: No there is no one procedure to generate repliation support for all tables of a schema.

However, as you stated, it shuld be fairly simple to generate a base script using dynamic SQL
(Although I usually prefer perl for these tasks).

Anurag Received on Thu Sep 18 2003 - 11:30:10 CDT