Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1150
  • Last Modified:

Materialized Views - Stop Redo Log Creation

We are experimenting with materialized views and have run into problems with redo logs being generated when doing a refresh force on demand. Certain proposals have been made, such as to change the ATOMIC_REFRESH on the refresh statement. What syntax would you use to do this and can this be done per materialized view?

The materialized view is refreshed every 30 seconds and we don't want the refresh interval to change. A fast refresh can't be used - we get a ORA-12015: cannot create a fast refresh mv from a complex query error. Have looked into using NOLOGGING but there are various articles saying that this doesn't stop redo log creation.

Does anyone have any other suggestions?

0
richcoit
Asked:
richcoit
  • 2
2 Solutions
 
DavidSenior Oracle Database AdministratorCommented:
No viable alternatives that I'm aware of, other than to run the instance in NOARCHIEVELOG mode.  Not recommended....
 
0
 
richcoitAuthor Commented:
Running the instance in NOARCHIVELOG mode is not an option.

Do you have any comments on any of the other points in the question, in particular, can the ATOMIC_REFRESH be changed per materialized view (as articles say to change this parameter on the refresh statement) and if so, how do you do this?
0
 
richcoitAuthor Commented:
sdsdsdsdsdsdsdsdsdsdsdsdsdsd
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now