Re: replicating DDL

I wish to add a column to a replicated table. What is the best way to do this if dbms_repcat.execute_ddl is not a suitable option.

"David Simpson" <dsimpson_at_dotcomsolutionsinc.net> wrote in message news:<5tSJ8.134740$L76.216572_at_rwcrnsc53>...
> Peter,
> I generally avoid replicating DDL. I wouldn't want a dropped table to
> propagate throughout my servers.
>
>
> David Simpson
> www.dotcomsolutionsinc.net
> "Peter McKenzie" <peter.mckenzie_at_health.wa.gov.au> wrote in message
> news:5b8660ac.0205290217.6affc754_at_posting.google.com...
> > I have just used the dbms_repcat.execute_ddl to add a column to a
> > table at the master site. This has successfully added the column at
> > the master but the column has not appeared at the snapshot sites.
> > Oracle7 Server Release 7.3.4.3.0. As far as the data is concerned the
> > only replication is from slave (snapshot) to master. Does this also
> > apply to DDL. If so what is the next step. Thanks in anticipation.
Received on Tue Jun 04 2002 - 04:24:03 CEST