On Commit Clause in Create Snapshot(ORA-12054) [message #75527] |
Fri, 30 July 2004 01:30 |
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
|
|
|
|
|