Just an additional note,

I am using Oracle 8.1.7 Enterprise edition and I dont see create any materialzed view system privilege in Enterprise manager which I need to grant according to the documentation.

Thanks
Anurag