Hi ,

I have two oracle database servers on separate machines:

1)db1 (machine 1 on windows 2000 PRofessional)
scott schema with emp table

2)db2 (machine 2 on Linux OS )
asif schema

now asif user at db2 try to create a materialized view of db1 scott.emp table

connect to asif user

Run Script(source code)

create materialized view employee_mv
tablespace "users"
build immediate using no index
refresh force on commit
with rowid using default local rollback segment
disable query rewrite
as
select empno,deptno,ename,sal from [Email Address Removed] ;
note: link1 is the database link points to db1 machine scott schema

===================================================================
Error
===================================================================
select empno,deptno,ename,sal from [Email Address Removed] *
ERROR at line 8:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized
view
========================================================================
Problem:
I must create materialized view with these option is mandatory based on
system requirements. can anybody help for solution.

from

Nabeel Ahmed
Software Developer
Al-Karam Textiles



Oracle LazyDBA home page