Home » Server Options » Replication » direct path load and mview refresh (oracle 10.2.0.5, hpux v11.31 ia.)
direct path load and mview refresh [message #604655] Thu, 02 January 2014 04:28 Go to next message
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 #604667 is a reply to message #604655] Thu, 02 January 2014 09:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59786
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No.

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
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.
Previous Topic: conflict resolution involving TIMESTAMP
Next Topic: Refresh Matrial View for select rows
Goto Forum:
  


Current Time: Wed Nov 26 05:40:56 CST 2014

Total time taken to generate the page: 0.12570 seconds