Adding a column to a replicated table
- From: "Orr, Steve" <sorr@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Jun 2005 08:47:02 -0600
I have a read only materialized view on one server and the master table
on another server. I need to add a column to the master table and the
materialized view is NOT defined with=20
< create materialized view ... as select * from table@mastersite >
The MV specifies the columns to replicate and I'm not interested in
replicating the new column. Do I still need to perform the DDL via the
dbms_repcat.alter_master_repobject(...) package procedure? Will
replication break if I alter the master table without this? (9.2/RHEL3)
TIA,
Steve Orr
Bozeman, Montana
--
//www.freelists.org/webpage/oracle-l
Other related posts:
