| Materialized view [message #551797] |
Fri, 20 April 2012 14:09  |
 |
parker214u
Messages: 19
Registered: February 2011
|
Junior Member |
|
|
Hi All,
I want to create a materialized view to fetch the data quickly for BI publisher reports. Now the user want to see the current month and previous months data. So is there a way to create a materialized view to incrementally referesh the data without disturbing the old month data.
Any document or suggestions please..
|
|
|
|
| Re: Materialized view [message #551799 is a reply to message #551797] |
Fri, 20 April 2012 14:28  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
From your previous topics:
BlackSwan wrote on Tue, 17 April 2012 15:29Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
cookiemonster wrote on Tue, 17 April 2012 15:38Do you realise how vauge that is?
...
BlackSwan wrote on Tue, 30 August 2011 22:37>...It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Michel Cadot wrote on Wed, 31 August 2011 08:03What is your Oracle version, with 4 decimals?
Post the CREATE TABLE statement you use.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
...
And you didn't feedback nor thanks those that (try to) help you.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
