Home » Server Options » Replication » MV
MV [message #276437] Thu, 25 October 2007 02:55 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
i m using 10.2.0.2.


CREATE TABLE TEST (A NUMBER PRIMARY KEY, B NUMBER);

CREATE MATERIALIZED VIEW LOG ON test with rowid;

CREATE MATERIALIZED VIEW mv_test TABLESPACE DATA03 REFRESH FAST ON COMMIT
AS (select b from test);

I m getting the following error,
ORA-23415: materialized view log for "sadat"."TEST" does not record the primary
key

CREATE MATERIALIZED VIEW LOG ON test WITH PRIMARY KEY;
it fixes the problem.

But i wanna kno why i cant create that view with rowid.

can any 1 help me??

thanx
Re: MV [message #276480 is a reply to message #276437] Thu, 25 October 2007 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you read and follow OraFAQ Forum Guide?

Regards
Michel
Re: MV [message #276669 is a reply to message #276480] Thu, 25 October 2007 22:42 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
I think PRIMARY KEY is the default. You would need REFRESH FAST WITH ROWID.

Ross Leishman
Previous Topic: Materialized View Refresh
Next Topic: Refresh Completed or Not
Goto Forum:
  


Current Time: Thu Mar 28 15:06:10 CDT 2024