Have a look at this Doc on Metalink Note:101705.1
-----Original Message-----
From: nabeelahmed
[mailto:oracledba-ezmlmshield-x89882771.[Email address protected]
Sent: 04 July 2006 07:15
To: LazyDBA Discussion
Subject: [Fwd: Need some help ORA-12054: cannot set the ON COMMIT
refresh attribute for the materialized view]
---------------------------- Original Message
----------------------------
Subject: Need some help ORA-12054: cannot set the ON COMMIT refresh
attribute for the materialized view From: [Email Address Removed] Sat, July 1, 2006 12:14 pm
To: [Email address protected]
------------------------------------------------------------------------
--
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
This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.
Oracle LazyDBA home page