{"id":903,"date":"2018-11-01T16:00:45","date_gmt":"2018-11-01T07:00:45","guid":{"rendered":"https:\/\/vongg.com\/?p=903"},"modified":"2018-11-01T16:19:35","modified_gmt":"2018-11-01T07:19:35","slug":"db-%e4%be%bf%e5%88%a9sql%e6%96%87","status":"publish","type":"post","link":"https:\/\/vongg.com\/?p=903","title":{"rendered":"DB \u4fbf\u5229SQL\u6587"},"content":{"rendered":"<p><strong>oracle \uff1a<\/strong><\/p>\n<p>\uff11\u3001\u6307\u5b9a\u9805\u76ee\u6240\u5728\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7<\/p>\n<p>SELECT TABLE_NAME , DATA_LENGTH FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = &#8216;colume\u540d&#8217;<\/p>\n<p>\uff12\u3001DB\u30c7\u30fc\u30bf\u306eExport\u3068Import<\/p>\n<p>expdp system\/\u30d1\u30b9\u30ef\u30fc\u30c9@DB\u540d directory=expdb_dir tables=\u30b9\u30ad\u30fc\u30de.\u30c6\u30fc\u30d6\u30eb\u540dPRE% content=data_only DUMPFILE=dump\u30d5\u30a1\u30a4\u30eb\u540d<\/p>\n<p>&#8212; DB \u30b5\u30fc\u30d0\u306b\u30ed\u30b0\u30a4\u30f3 &#8212;<br \/>\nsu &#8211; oracle<br \/>\n&#8212; \u2460 \u30b9\u30ad\u30fc\u30de@DB\u540d\u306e\u30c7\u30fc\u30bf\u3092TRANC<br \/>\nsqlplus \/nolog<br \/>\nconn \u30b9\u30ad\u30fc\u30de\/\u30d1\u30b9\u30ef\u30fc\u30c9@DB\u540d<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nSELECT &#8216;TRUNCATE TABLE &#8216; || table_name || &#8216;;&#8217; FROM USER_ALL_TABLES<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nimpdp system\/xxxx@DB\u540d directory=impdb_dir tables=\u30b9\u30ad\u30fc\u30de.\u30c6\u30fc\u30d6\u30eb\u540dPRE% DUMPFILE=dump\u30d5\u30a1\u30a4\u30eb\u540d.dmp content=data_only<\/p>\n<p>\uff13\u3001\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u53d6\u5f97<\/p>\n<p>select * from ALL_DIrectories;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>oracle \uff1a \uff11\u3001\u6307\u5b9a\u9805\u76ee\u6240\u5728\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7 SELECT TABLE_NAME , DATA_LENGTH [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21],"tags":[],"_links":{"self":[{"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts\/903"}],"collection":[{"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=903"}],"version-history":[{"count":4,"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts\/903\/revisions"}],"predecessor-version":[{"id":907,"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts\/903\/revisions\/907"}],"wp:attachment":[{"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}