| MV [message #276437] |
Thu, 25 October 2007 02:55  |
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 #276669 is a reply to message #276480] |
Thu, 25 October 2007 22:42  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
