Home » Server Options » Replication » Alter mview (Query) (Solaris9,Oracle
Alter mview (Query) [message #323365] Wed, 28 May 2008 05:42
Messages: 21
Registered: January 2008
Junior Member
Hi, All

I need to alter the sql query of a existing mview,should i drop it and then recreate or any method to alter that one.

The tables are of Production database and are large ones.

Total size of tables are 150GB(4 Tables),so mview recreation will take much time.

Suggest me the right method.


Previous Topic: replication with oracle xe
Next Topic: trigger: after update on materialized view
Goto Forum:

Current Time: Mon Nov 29 23:26:10 CST 2021