direct path load and mview refresh [message #604655] |
Thu, 02 January 2014 04:28 |
snowball
Messages: 229 Registered: April 2006 Location: China
|
Senior Member |
|
|
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 |
snowball
Messages: 229 Registered: April 2006 Location: China
|
Senior Member |
|
|
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.
|
|
|