Re: replicating DDL

From: David Simpson <dsimpson_at_dotcomsolutionsinc.net>
Date: Fri, 31 May 2002 22:05:53 GMT
Message-ID: <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 Sat Jun 01 2002 - 00:05:53 CEST

Original text of this message