{"height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkenken0807.hatenablog.com%2Fentry%2F2016%2F02%2F29%2F173312\" title=\"Oracle \u5225\u30b9\u30ad\u30fc\u30de\u9593\u3067FAST REFRESH ON COMMIT\u30e2\u30fc\u30c9\u306e\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3059\u308b - kenken0807_DB\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"\u30b9\u30ad\u30fc\u30deMVIEW_MOTO\u306e\u30c6\u30fc\u30d6\u30ebTEST\u306b\u5bfe\u3057\u3066 \u30b9\u30ad\u30fc\u30deMVIEW_SAKI\u306bFAST REFRESH ON COMMIT\u30e2\u30fc\u30c9\u306e\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3059\u308b MVIEW_MOTO\u306b\u30c6\u30fc\u30d6\u30eb\u3068\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u30ed\u30b0\u306e\u4f5c\u6210 CREATE TABLE test (id NUMBER,id2 NUMBER,del_flg NUMBER,CONSTRAINT test_pk PRIMARY KEY(id)); CREATE MATERIALIZED VIEW LOG ON test; \u6a29\u9650\u306e\u4ed8\u4e0e MVIEW_SAKI\u306bMVIEW_MOTO\u306etest\u30c6\u30fc\u30d6\u30eb\u3068\u30de\u30c6\u30d3\u30e5\u30fc\u30ed\u30b0\u306b\u5bfe\u3057\u3066\u306eSE\u2026","provider_url":"https://hatena.blog","blog_title":"kenken0807_DB\u30e1\u30e2","categories":["ORACLE SE"],"version":"1.0","width":"100%","type":"rich","url":"https://kenken0807.hatenablog.com/entry/2016/02/29/173312","title":"Oracle \u5225\u30b9\u30ad\u30fc\u30de\u9593\u3067FAST REFRESH ON COMMIT\u30e2\u30fc\u30c9\u306e\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3059\u308b","author_url":"https://blog.hatena.ne.jp/kenken0807/","image_url":null,"blog_url":"https://kenken0807.hatenablog.com/","provider_name":"Hatena Blog","published":"2016-02-29 17:33:12","author_name":"kenken0807"}