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
Have a look at MOS Bug 5217296 - ORA-32411 reported on materialized view refresh [ID 5217296.8]
This is a restriction in 10.2 (and above), there is a workaround mentioned; however I wouldn't go for it. As this limit doesn't apply to views why don't you create a view upon your whole select statement and then in your materialized view simply do a