Database DataWarehousing (MOSC)

MOSC Banner

refresh materialized view without create archive log.

edited Mar 15, 2011 8:57AM in Database DataWarehousing (MOSC) 6 commentsAnswered
hello,

      I have created a materialized view and when it's refreshed then 1 Go archived log are created.

It's refreshed everey 5 minutes, it's why for me it's a problem because my file system of archive is quickly full.

I have tried to create my meterialized view with the option "nologging" and tablespace nologging too, but always when my materialized view is refreshed create archive log.

My question is : I would like have my database in mode archivelog except my materialized view.

Who can help me ? because I do not find the solution.

regards

JP

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center