OraFAQ Forum: Replication » how to alter materialized view object

Home » Server Options » Replication » how to alter materialized view object (Oracle 10g + Windows 2000 + Advanced Replication)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to alter materialized view object [message #300848]

Mon, 18 February 2008 04:36

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi,

In my replication environment, I am having one table in master and materialized view site having one snapshot based one master site table.

Now i need to add some new columns in my base table, using dbms_repcat.alter_master_repobject i can able to add but i want to add newly created column in materialized view site also with out dropping snapshot.

It's possible? any packages available?

Babu

Report message to a moderator

Previous Topic:	create materialized view + insufficient privileges
Next Topic:	Replication solutions with Oracle 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:40:16 CST 2025