Quote Originally Posted by needy View Post
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 12003:
I have not tried importing an MV into another schema but what I want to emphasize is that error list signifies the lack of privilege for creating materialized view. Did u give 'create materialized view' or 'create any materialized view' privilege to user2?