All:

I did some experimenting and finally found from Oracle that "on commit" you can use only if you have your master table in the same database where you are creating MView. Therefore, on commit is not suported in remote databases. Another way you can use remote database if you replace your line "REFRESH ON COMMIT" with "refresh fast on demand with primary key" and this works.