direct path load and mview refresh [message #604655] |
Thu, 02 January 2014 04:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
snowball
Messages: 229 Registered: April 2006 Location: China
|
Senior Member |
![xueyuan.luo@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Hi, guru
Is it possible for using direct path load on master table , while those data can also updated through fast refreshing on slave site(which create mview)?
I have tried on my env, but it turn out to be that, it won't log those changed data to mview log.
Thanks very much.
[Updated on: Thu, 02 January 2014 04:30] Report message to a moderator
|
|
|
|
Re: direct path load and mview refresh [message #604669 is a reply to message #604667] |
Thu, 02 January 2014 09:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
snowball
Messages: 229 Registered: April 2006 Location: China
|
Senior Member |
![xueyuan.luo@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Hi, Machel
If master of mview can not load data from direct path load way, then what will be the better alternative way to do this?
Create a view on that mater table, then base on the view create mview on slave site?
Thanks very much.
|
|
|