Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Adding a column to a replicated table
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_at_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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 14 2005 - 10:52:11 CDT
![]() |
![]() |