Solved

Materialized Views - Stop Redo Log Creation

Posted on 2009-04-09
3
1,111 Views
Last Modified: 2013-12-18
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
Comment
Question by:richcoit
  • 2
3 Comments
 
LVL 23

Assisted Solution

by:David
David earned 150 total points
Comment Utility
No viable alternatives that I'm aware of, other than to run the instance in NOARCHIEVELOG mode.  Not recommended....
 
0
 

Accepted Solution

by:
richcoit earned 0 total points
Comment Utility
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
 

Author Comment

by:richcoit
Comment Utility
sdsdsdsdsdsdsdsdsdsdsdsdsdsd
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now