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 ?
|
|
|