Home » Server Options » Replication » IS there any alternative for dbms_mview.refresh
IS there any alternative for dbms_mview.refresh [message #157236] Wed, 01 February 2006 03:48 Go to next message
rr9876r
Messages: 12
Registered: April 2005
Junior Member
Is there any alternative for dbms_mview.refresh process, which runs fater than dbms_mview.refresh? I am copying the table data (dbms_mview.refresh('TABLE1')) from one database from server to another database in another server. I have bunch of table to copy and taking the moretime to do this. I am looking for alternative, which is better than dbms_mview.refresh.
Re: IS there any alternative for dbms_mview.refresh [message #158596 is a reply to message #157236] Mon, 13 February 2006 06:51 Go to previous message
princess
Messages: 4
Registered: January 2006
Location: Alexandria
Junior Member

hai

-is yr materialized view type is complex
if yes and u wanna save time u have to drop and recreate it ,faser than refreshing it compelete
-if it is fast refresh u has no option either using dbms_mview.refresh or using enterprise manager conasole to refresh it or try dbms_refresh.refresh('table1')



regards
Previous Topic: performance hit in synchronous replication
Next Topic: Masterless replication
Goto Forum:
  


Current Time: Wed Jan 20 08:28:28 CST 2021