Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Adding a column to a replicated table

Adding a column to a replicated table

From: Orr, Steve <sorr_at_rightnow.com>
Date: Tue, 14 Jun 2005 08:47:02 -0600
Message-ID: <E418CEC8B5FB3E48B30FA22F092886E75101C4@RNT-BOZ-0201.corp.rightnow.com>


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-l
Received on Tue Jun 14 2005 - 10:52:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US