Home » Server Options » Replication » Alter mview (Query) (Solaris9,Oracle 9.2.0.8)
Alter mview (Query) [message #323365] Wed, 28 May 2008 05:42
vishal_srivastava
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.


Thanks.



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


Current Time: Thu Mar 28 11:09:22 CDT 2024