{"id":43,"date":"2011-08-27T23:41:02","date_gmt":"2011-08-27T15:41:02","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=43"},"modified":"2011-09-22T18:35:14","modified_gmt":"2011-09-22T10:35:14","slug":"%e7%89%a9%e5%8c%96%e8%a7%86%e5%9b%be%e5%bf%ab%e9%80%9f%e5%88%b7%e6%96%b0%e4%b8%8d%e6%94%af%e6%8c%81%e6%a0%87%e5%87%86%e5%a4%96%e8%81%94%e6%8e%a5%e5%86%99%e6%b3%95","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=43","title":{"rendered":"\u7269\u5316\u89c6\u56fe\u5feb\u901f\u5237\u65b0\u4e0d\u652f\u6301\u6807\u51c6\u5916\u8054\u63a5\u5199\u6cd5"},"content":{"rendered":"<p>\u53d1\u73b0\u5bf9\u4e8eREFRESH FAST ON COMMIT\u7269\u5316\u89c6\u56fe\uff0c\u5e76\u4e0d\u652f\u6301\u6807\u51c6\u5916\u8fde\u63a5\u7684\u5199\u6cd5\uff0c\u800cOracle\u7279\u6709\u7684(+)\u65b9\u5f0f\u5219\u6ca1\u6709\u95ee\u9898\u3002<br \/>\nOracle\u5bf9\u4e8e\u6807\u51c6\u5916\u8054\u63a5\u7684\u5199\u6cd5\u652f\u6301\u7684\u5e76\u4e0d\u597d\uff0c\u7c7b\u4f3c\u7684bug\u5df2\u7ecf\u4e0d\u662f\u7b2c\u4e00\u6b21\u78b0\u5230\u4e86\u3002<\/p>\n<pre lang='SQL'>SQL> CREATE TABLE T_P (ID NUMBER PRIMARY KEY, NAME VARCHAR2(30));\r\n\u8868\u5df2\u521b\u5efa\u3002\r\nSQL> CREATE TABLE T_F (ID NUMBER PRIMARY KEY, FID NUMBER);\r\n\u8868\u5df2\u521b\u5efa\u3002\r\nSQL> CREATE MATERIALIZED VIEW LOG ON T_P\r\n  2  WITH ROWID (ID);\r\n\u5b9e\u4f53\u5316\u89c6\u56fe\u65e5\u5fd7\u5df2\u521b\u5efa\u3002\r\nSQL> CREATE MATERIALIZED VIEW LOG ON T_F\r\n  2  WITH ROWID (FID);\r\n\u5b9e\u4f53\u5316\u89c6\u56fe\u65e5\u5fd7\u5df2\u521b\u5efa\u3002\r\nSQL> CREATE MATERIALIZED VIEW MV_T_ORACLE\r\n  2  REFRESH FAST ON COMMIT\r\n  3  AS SELECT A.ROWID A_RID, B.ROWID B_RID, A.ID, FID, NAME\r\n  4  FROM T_P A, T_F B\r\n  5  WHERE A.ID = FID (+);\r\n\u5b9e\u4f53\u5316\u89c6\u56fe\u5df2\u521b\u5efa\u3002\r\nSQL> CREATE MATERIALIZED VIEW MV_T_STARDAND\r\n  2  REFRESH FAST ON COMMIT\r\n  3  AS SELECT A.ROWID A_RID, B.ROWID B_RID, A.ID, FID, NAME\r\n  4  FROM T_P A LEFT JOIN T_F B\r\n  5  ON A.ID = FID;\r\nFROM T_P A LEFT JOIN T_F B\r\n*\r\n\u7b2c 4 \u884c\u51fa\u73b0\u9519\u8bef:\r\nORA-12054: \u65e0\u6cd5\u4e3a\u5b9e\u4f53\u5316\u89c6\u56fe\u8bbe\u7f6e ON COMMIT \u5237\u65b0\u5c5e\u6027\r\n\r\nSQL> CREATE MATERIALIZED VIEW MV_T_STARDAND\r\n  2  REFRESH FAST \r\n  3  AS SELECT A.ROWID A_RID, B.ROWID B_RID, A.ID, FID, NAME\r\n  4  FROM T_P A LEFT JOIN T_F B\r\n  5  ON A.ID = FID;\r\nFROM T_P A LEFT JOIN T_F B\r\n*\r\n\u7b2c 4 \u884c\u51fa\u73b0\u9519\u8bef:\r\nORA-12015: \u4e0d\u80fd\u4ece\u590d\u6742\u67e5\u8be2\u4e2d\u521b\u5efa\u4e00\u4e2a\u53ef\u5feb\u901f\u5237\u65b0\u7684\u5b9e\u4f53\u5316\u89c6\u56fe\r\n\r\nSQL> CREATE MATERIALIZED VIEW MV_T_STARDAND\r\n  2  REFRESH FAST \r\n  3  AS SELECT A.ROWID A_RID, B.ROWID B_RID, A.ID, FID, NAME\r\n  4  FROM T_P A INNER JOIN T_F B\r\n  5  ON A.ID = FID;\r\nFROM T_P A INNER JOIN T_F B\r\n*\r\n\u7b2c 4 \u884c\u51fa\u73b0\u9519\u8bef:\r\nORA-12015: \u4e0d\u80fd\u4ece\u590d\u6742\u67e5\u8be2\u4e2d\u521b\u5efa\u4e00\u4e2a\u53ef\u5feb\u901f\u5237\u65b0\u7684\u5b9e\u4f53\u5316\u89c6\u56fe<\/pre>\n<p>\u4ece\u4e0a\u9762\u7684\u7269\u5316\u89c6\u56fe\u521b\u5efa\u8bed\u53e5\u4e0d\u96be\u770b\u51fa\uff0cOracle\u5e76\u975e\u4e0d\u652f\u6301\u5916\u8054\u63a5\u7684\u65b9\u5f0f\uff0c\u91c7\u7528(+)\u65b9\u5f0f\u521b\u5efa\u7684\u7269\u5316\u89c6\u56fe\u662f\u53ef\u4ee5\u6210\u529f\u7684\uff0c\u4f46\u662f\u5982\u679c\u91c7\u7528\u4e86\u6807\u51c6SQL\u65b9\u5f0f\uff0c\u4e0d\u8981\u8bf4ON COMMIT\u65b9\u5f0f\uff0c\u6216\u8005\u5305\u542b\u5916\u8054\u63a5\u4e86\uff0c\u5c31\u662f\u666e\u901a\u5185\u8fde\u63a5\u521b\u5efa\u5feb\u901f\u5237\u65b0\u7684\u7269\u5316\u89c6\u56fe\u4ecd\u7136\u4f1a\u51fa\u73b0\u9519\u8bef\u3002<br \/>\n\u6240\u4ee5\u95ee\u9898\u7684\u6839\u6e90\u8fd8\u662f\u6807\u51c6\u5199\u6cd5\uff0c\u65e2\u7136\u4f7f\u7528\u7684\u662fOracle\u6570\u636e\u5e93\uff0c\u8fd8\u662f\u4f7f\u7528Oracle\u63d0\u4f9b\u7684\u8bed\u6cd5\u51fa\u9519\u7684\u6982\u7387\u6700\u5c0f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53d1\u73b0\u5bf9\u4e8eREFRESH FAST ON COMMIT\u7269\u5316\u89c6\u56fe\uff0c\u5e76\u4e0d\u652f\u6301\u6807\u51c6\u5916\u8fde\u63a5\u7684\u5199\u6cd5\uff0c\u800cOracle\u7279\u6709\u7684(+)\u65b9\u5f0f\u5219\u6ca1\u6709\u95ee\u9898\u3002 Oracle\u5bf9\u4e8e\u6807\u51c6\u5916\u8054\u63a5\u7684\u5199\u6cd5\u652f\u6301\u7684\u5e76\u4e0d\u597d\uff0c\u7c7b\u4f3c\u7684bug\u5df2\u7ecf\u4e0d\u662f\u7b2c\u4e00\u6b21\u78b0\u5230\u4e86\u3002 SQL> CREATE TABLE T_P (ID NUMBER PRIMARY KEY, NAME VARCHAR2(30)); \u8868\u5df2\u521b\u5efa\u3002 SQL> CREATE TABLE T_F (ID NUMBER PRIMARY KEY, FID NUMBER); \u8868\u5df2\u521b\u5efa\u3002 SQL> CREATE MATERIALIZED VIEW LOG ON T_P 2 WITH ROWID (ID); \u5b9e\u4f53\u5316\u89c6\u56fe\u65e5\u5fd7\u5df2\u521b\u5efa\u3002 SQL> &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=43\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[73,69,71,72,70],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-H","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/43"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=43"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/43\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}