Hi Nabeel ,

Just one hour ago I was also facing same problem.
But after googling on one forum it was written that we can not use ON
COMMIT, if using db link in query.

Rakesh

----- Original Message -----
From: "nabeelahmed"
<oracledba-ezmlmshield-x46288020.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, July 01, 2006 12:44 PM
Subject: Need some help ORA-12054: cannot set the ON COMMIT refresh
attribute for the materialized view


> 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
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page