By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

Materialized view Refresh

P: 3
I have a query thats taking long time to execute. So i have created a Materialized view to refresh it every hour. But when the Materialized view is being refreshed, there is no data in the Materialized view table. I think it truncates the table before every refresh.

Is there any way to keep the old data while its being refreshed.?
Sep 18 '09 #1
Share this Question
Share on Google+
3 Replies

P: 188
I'm not sure if i could help you or not.. but could you provide more information like.. your table structure, your materialized view query and all.... so that we would be able to get more insight on your problem.

Sep 19 '09 #2

Expert 100+
P: 2,367
Please provide the below information:

1. The version of the database that you are using?
2. The CREATE MV statement that you have used?
3. The amount of time it takes to REFRESH the MV?
4. The scheduled Job if any that you are using to REFRESH the MV.
Sep 23 '09 #3

P: 6
You can use on prebuilt table clause when you create a materialized view

Follow the link
Mar 1 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.