refresh materialized view without create archive log.
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