| Question on refreshing Materialised Views in [message #75434] |
Tue, 23 December 2003 03:56 |
Donald ferreira
Messages: 6
Registered: December 2003
|
Junior Member |
|
|
Hi,
I was trying to create a MV on a Oracle Financials view ar_payment_schedules table, which didn't worked, so I created the MV on it's standard table ar_payment_schedules_all. This table contains around 1400216 records. Following were the steps which I performed :
-Create MV log on the table
-Create MV refresh fast with the select statements which has quite a decode and sum statements, on the above table, START WITH SYSDATE
NEXT SYSDATE+0.0001
-the first time I try to query the MV, I see the data, BUT after that for ages, I don't see any records in the MV, it's just empty all the time. I know during the refresh the MV goes emoty on complete refresh
I would like if someone could tell me, how to get the real time data in my MV. Like there is a modification in the standard table and it is refreshed in 5-10 minutes in my MV, keeping the other records intact and only updating the required ones from the log table
I will appreciate if you can advice me on the same
greetings
Donald Ferreira
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
