Home » Server Options » Replication » readonly mview setup problem
readonly mview setup problem [message #142479] Fri, 14 October 2005 14:28
aliyesami
Messages: 28
Registered: October 2005
Location: Florida
Junior Member
Hi !
I have two nodes nodeA , nodeB
on nodeA i have a table XY , I created the MV log on this table .
I am trying to create the MView on nodeB as follows:

CREATE MATERIALIZED VIEW "CAMTEST"."XY_MV"
TABLESPACE "USERS"
BUILD IMMEDIATE
USING INDEX
TABLESPACE "USERS"
REFRESH COMPLETE
ON DEMAND
AS
SELECT * FROM XY@ECOMMT.WORLD << this dabase link works.


I get the error :
ORA-12014:table "XY" does not contain a primary key constraint.


The table XY does have a primary key.

my question is : do I have to creat the table XY on nodeB before creating the MV ?

Previous Topic: Replication questions
Next Topic: Oracle Streams
Goto Forum:
  


Current Time: Thu Mar 28 04:50:50 CDT 2024