Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Server Options » Replication » how to alter materialized view object (Oracle 10g + Windows 2000 + Advanced Replication)
how to alter materialized view object [message #300848] Mon, 18 February 2008 04:36
gentlebabu
Messages: 235
Registered: December 2005
Location: India, Bangalore
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:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 4 16:20:30 CDT 2008

Total time taken to generate the page: 0.00846 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.