Home » Server Options » Replication » On Commit Clause in Create Snapshot(ORA-12054)
On Commit Clause in Create Snapshot(ORA-12054) [message #75527] Fri, 30 July 2004 01:30 Go to next message
Sachin Pawar
Messages: 3
Registered: June 2004
Junior Member
I am creating a Materialized view with following cluases,

CREATE MATERIALIZED VIEW XYZ
NOLOGGING
NOCACHE
NOPARALLEL
REFRESH FORCE
ON COMMIT
WITH ROWID
USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS
SELECT *
FROM
XYZ@remote_DB

This gives me error
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

Any help is appreciated,
Thanks
Re: On Commit Clause in Create Snapshot(ORA-12054) [message #75536 is a reply to message #75527] Tue, 24 August 2004 23:57 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

"ON COMMIT" works with local tables only - you cannot use DB Links.

Somehow this is not properly documented in the Oracle Manuals. See documentation bug 960322.

Best regards.

Frank
Re: On Commit Clause in Create Snapshot(ORA-12054) [message #75539 is a reply to message #75527] Mon, 30 August 2004 20:57 Go to previous message
Suman Dasgupta
Messages: 22
Registered: August 2004
Junior Member
The refresh on commit option will work only with the local tables (i.e. the tables from where you are creating the materialized views are located in the same database server)... It won't work with the dblinks i.e. for the remote database servers....
Previous Topic: How set up an Oracle Replication Server
Next Topic: distributed transaction lock
Goto Forum:
  


Current Time: Thu Mar 28 20:18:42 CDT 2024