所以我非常肯定甲骨文支持这一点,所以我不知道我做错了什么.此代码可以工作:
CREATE MATERIALIZED VIEW MV_Test
NOLOGGING
CACHE
BUILD IMMEDIATE
REFRESH FAST ON COMMIT
AS
SELECT V.* FROM TPM_PROJECTVERSION V;
如果我添加连接,它会断开:
CREATE MATERIALIZED VIEW MV_Test
NOLOGGING
CACHE
BUILD IMMEDIATE
REFRESH FAST ON COMMIT
AS
SELECT V.*, P.* FROM TPM_PROJECTVERSION V
INNER JOIN TPM_PROJECT P ON P.PROJECTID = V.PROJECTID
现在我得到了一个错误:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view个
我已经在TPM_PROJECT和TPM_PROJECTVERSION上创建了materialized 视图日志(log).TPM_PROJECT的主键为PROJECTID,TPM_PROJECTVERSION的复合主键为(PROJECTID,VERSIONID).这有什么诀窍?我一直在翻阅甲骨文的手册,但一无所获.谢谢