replicating DDL
From: Peter McKenzie <peter.mckenzie_at_health.wa.gov.au>
Date: 29 May 2002 03:17:29 -0700
Message-ID: <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 Wed May 29 2002 - 12:17:29 CEST
Date: 29 May 2002 03:17:29 -0700
Message-ID: <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 Wed May 29 2002 - 12:17:29 CEST