Problem creating materialized view with primary key

[sam93]

Hi,

I'm having problem creating a materialized view with primary key. Here's my situation:
I've got a mat. view (say M1) created on 3 underlying tables using REFRESH FAST ON DEMAND. The MAT. VIEW LOGs on the 3 tables are built using WITH ROWID option.
I'm trying to build another mat. view (say M2) in another database, using a DB link, based on mat. view M1, using WITH PRIMARY KEY option. I've got PK constraint on M1 and the mat. view log that I've created on M1 includes WITH PRIMARY KEY clause. However, I'm unable to build the new mat. view using WITH PRIMARY KEY option.
The database which has mat. view M1 is 8i. I'm trying to create the new mat. view in a 9i database.
Am I missing any pieces or is this an issue because of different database versions?
There are no aggregations involved in any of the mat. views.

Thanks.

 

[eagertotry]

Could you elaborate on:

I'm unable to build the new mat. view using WITH PRIMARY KEY option

What's happening? Are you getting an error? It would be nice if you could post a sample of the DDL you're using to do this stuff, at least the one that is giving the error.

Tks