2 Replies Latest reply: Nov 28, 2012 12:10 AM by 956054 RSS

    how to fix ora-32411

      Hi All,
      i am creating materialized view and it has been created successfully but at the time of refreshment error ora-32411 is coming my query length is more than 4000 and i can't split this query so please guide me on this, Is there anything that can be done, besides splitting up the query? The scripts are one long query each so it will be hard to split up and i my boss don't want to split or recreate this query. kindly help me on this

      query length is 74k, 104k and more..

      Thanks in advance