0 Replies Latest reply on Nov 30, 2016 5:01 AM by Shaik

    How to disable MATERIALIZED VIEW LOG

    Shaik

      Hi All,

       

      My environment

      Apps: R12.1.3

      Db:11.2.0.3

       

       

      In my environment many custom Materialized view created and MV log growing huge.

       

      Here i want to disable the MV Log, searched many docs , i can see drop option for MV log

       

      Is disable option available for MV log, please suggest

       

      https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8021.htm#SQLRF01524

       

      Regards

      Shaik