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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 04:58:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.