Materialized view Refresh

[kewldotnet]

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.?

[rpnew]

Hi,
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.

Thanks,
RP

[amitpatel66]

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.

[Madhusmita Biswal]

materialized view

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

Follow the link