{"id":1613,"date":"2024-05-08T15:19:03","date_gmt":"2024-05-08T07:19:03","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1613"},"modified":"2024-05-08T15:19:03","modified_gmt":"2024-05-08T07:19:03","slug":"%e5%8e%8b%e6%b5%8b%e6%95%b0%e6%8d%ae%e5%88%a0%e9%99%a4","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1613","title":{"rendered":"\u538b\u6d4b\u6570\u636e\u5220\u9664"},"content":{"rendered":"<pre><code class=\"language-sql\">deleteptestdata.sh:\n\nsqlplus dbuser\/pwd &lt;&lt;EOF &gt;deleteptestdata.log\n@deleteptestdata.sql\nexit\nEOF\n\n--\u67d0\u4e2a\u8868\u5904\u7406:\nalter session enable parallel dml;\nalter table dbuser.passwd  nologging;\ndelete \/*+ PARALLEL(t1,4) *\/ from  dbuser.passwd t1 where id like &#039;20451477%&#039;;\ncommit;\n\nalter table dbuser.dbname  logging;\n\n--\u91ca\u653e\u8868\u7a7a\u95f4\nalter table tablename enable row movement ;\nALTER TABLE tablename SHRINK SPACE COMPACT;\nALTER TABLE tablename SHRINK SPACE cascade;\n\ncommit;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>deleteptestdata.sh: sqlplus dbuser\/pwd &lt;&lt;EOF &gt;deleteptestdata.log @deleteptestdata.sql exit EOF &#8211;\u67d0\u4e2a\u8868\u5904\u7406: alter session enable parallel dml; alter table dbuser.passwd nologging; delete \/*+ PARALLEL(t1,4) *\/ from dbuser.passwd t1 where id like &#039;20451477%&#039;; commit; alter table dbuser.dbname logging; &#8211;\u91ca\u653e\u8868\u7a7a\u95f4 alter table tablename enable row movement ; ALTER TABLE tablename SHRINK SPACE COMPACT; ALTER TABLE tablename SHRINK SPACE cascade; commit;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82,101,80],"tags":[],"class_list":["post-1613","post","type-post","status-publish","format-standard","hentry","category-oracle","category-82","category-101","category-80"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1613"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1613\/revisions"}],"predecessor-version":[{"id":1614,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1613\/revisions\/1614"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}