Home » Server Options » Replication » MV Issue
MV Issue [message #201669] |
Mon, 06 November 2006 05:23  |
kkpareek
Messages: 5 Registered: November 2006
|
Junior Member |
|
|
Hi
I have a MV and MV log on the master and doing fast refresh. I am using this concept to aggregate the data in MV from detailed data.
Now, there is requirement to purge the underlying detailed data without droping data from MV.
How this can be done? I tried dropping the MV log on master and then purging data. It worked but I could not fast refresh when I created the MV log again (ORA-12034).
Any ideas?
Kailash Pareek
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Feb 19 02:26:59 CST 2025
|