Home » Fusion Middleware & Colab Suite » Business Intelligence » Materialized view (Oracle11g)
Materialized view [message #551797] Fri, 20 April 2012 14:09 Go to next message
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 Go to previous message
Michel Cadot
Messages: 67667
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topics:

BlackSwan wrote on Tue, 17 April 2012 15:29
Please read and follow the forum guidelines, to enable us to help you:


cookiemonster wrote on Tue, 17 April 2012 15:38
Do 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:03
What 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.


Previous Topic: Removing "OracleBI spreadsheet add-in"
Next Topic: Forecasting and predictive solution in oracle BI
Goto Forum:

Current Time: Wed Jan 27 12:56:57 CST 2021