Home » Server Options » Replication » Materialized View with ORDIMAGE
icon9.gif  Materialized View with ORDIMAGE [message #123131] Fri, 10 June 2005 00:35
yoel
Messages: 1
Registered: June 2005
Location: Singapore
Junior Member
Hi guys,

I have a replicated environment using materialized view.
I encountered a problem when I tried to create a materialized
view on a table with ORDIMAGE datatype.
Basicly I can't create materialized view with both ORDSYS.ORDIMAGE and TIMESTAMP WITH LOCAL TIME ZONE,
I have to exclude one of those type which is not possible because both datatype are needed.

Can Anyone please help me on this
Thank you in advance

Regards,
Joel

below is the description :
SQL>desc VIVO_USER.assettypeimage@datacenter.world

Name Null? Type
-------------------------- -------- ------------------
TYPEID NOT NULL NUMBER(20)
IMAGE ORDSYS.ORDIMAGE
CREATE_BY VARCHAR2(20)
CREATE_DT TIMESTAMP(6) WITH
LOCAL TIME ZONE
CHANGE_BY VARCHAR2(20)
CHANGE_DT TIMESTAMP(6) WITH
LOCAL TIME ZONE

below is when i tried to create the materialized view :

SQL >CREATE MATERIALIZED VIEW VIVO_USER.ASSETTYPEIMAGE
2 REFRESH COMPLETE WITH PRIMARY KEY FOR UPDATE AS
3 SELECT A.TYPEID,A.IMAGE,A.CREATE_BY,
4 A.CREATE_DT,A.CHANGE_BY,A.CHANGE_DT
5 FROM VIVO_USER.assettypeimage@datacenter.world A;
FROM VIVO_USER.assettypeimage@datacenter.world A
*
ERROR at line 5:
ORA-00922: missing or invalid option

Below is when I tried to create the materialized view without
the ORDIMAGE Field which is IMAGE column :


SQL >CREATE MATERIALIZED VIEW VIVO_USER.ASSETTYPEIMAGE
2 REFRESH COMPLETE WITH PRIMARY KEY FOR UPDATE AS
3 SELECT A.TYPEID,A.CREATE_BY,
4 A.CREATE_DT,A.CHANGE_BY,A.CHANGE_DT
5 FROM VIVO_USER.assettypeimage@datacenter.world A;

Materialized view created.

Below is when I tried to create materialized view without
the TIMESTAMP WITH LOCAL TIMEZONE datatype (CREATE_DT and CHANGE_DT which are needed for replication Update conflict resolution) :


SQL>CREATE MATERIALIZED VIEW vivo_user.assettypeimage
2 REFRESH COMPLETE WITH PRIMARY KEY FOR UPDATE AS
3 SELECT A.TYPEID,A.IMAGE,A.CREATE_BY,A.CHANGE_BY FROM VIVO_USER.assettypeimage@datacenter.world A;

Materialized view created.





Previous Topic: Replication Issue
Next Topic: Refresh On Commit not refreshing accurately
Goto Forum:
  


Current Time: Thu Mar 28 04:53:13 CDT 2024