Oracle Solution for Error ora-12040

Solution for Oracle Error ORA-12040

ORA-12040: master rollback segment option not support by master site string

What triggered the Error:

An attempt was made to specify master rollback segment in the current operation. The master site of the current materialized view does not allow users to specify a rollback segment to be used for materialized view operations. This feature is only supported by Oracle8 or later master sites.

What should we do to fix it:

Do not specify a master rollback segment in the current operation or choose a new master site.