| IS there any alternative for dbms_mview.refresh [message #157236] |
Wed, 01 February 2006 03:48  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
