Thanks Anurag -- that's what I figured.
"Anurag Varma" <avarmadba.skipthis_at_yahoo.com> wrote in message news:<m4lab.10143$3%6.9895_at_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 - 17:40:20 CDT
