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: Sun Oct 23 23:13:43 CDT 2016

Total time taken to generate the page: 0.07976 seconds