{"id":1071,"date":"2016-01-02T13:16:17","date_gmt":"2016-01-02T13:16:17","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1071"},"modified":"2016-01-02T13:16:17","modified_gmt":"2016-01-02T13:16:17","slug":"segment-shrinking","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1071","title":{"rendered":"Segment shrinking"},"content":{"rendered":"<p><UL><br \/>\n<LI><SPAN style=\"COLOR: black\">Oracle Database 9i\uae4c\uc9c0\ub294 \uc138\uadf8\uba3c\ud2b8 HWM\uc774\ud558\uc5d0 \ud560\ub2f9\ub41c \uacf5\uac04\uc740 \uc624\uc9c1 \uc138\uadf8\uba3c\ud2b8\ub97c \uc774\uad00\ud558\uac70\ub098 \uc7ac \uc815\uc758\ud560 \ub54c \ubc18\ub0a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Oracle Database 10g\ubd80\ud130\ub294 \uc138\uadf8\uba3c\ud2b8\uc758 \ube48 \uacf5\uac04\uc744 shrink \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc138\uadf8\uba3c\ud2b8\uac00 shrink \ub420 \ub54c, \uadf8 \ub370\uc774\ud130\ub294 \uc9d1\uc57d\ub418\uace0 HWM \uc815\ubcf4\ub3c4 \ubcc0\uacbd\ub429\ub2c8\ub2e4. \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \uacf5\uac04\uc740 \uc138\uadf8\uba3c\ud2b8\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ubc18\ub0a9\ub418\uc5b4 \uc9d1\ub2c8\ub2e4. <\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile9.uf.246BFA4D5687CD9921A02F.png?w=640\" data-recalc-dims=\"1\" \/> <\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV>CTAS ,ITAS <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub97c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc774\uc6a9\ud574<\/SPAN> Table <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc0dd\uc131<\/SPAN> <\/DIV><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile10.uf.2419464B5687CD9C301D12.png?w=640\" data-recalc-dims=\"1\" \/> <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile6.uf.2327BC4F5687CD9C25B32F.png?w=640\" data-recalc-dims=\"1\" \/> <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV>Delete table <\/DIV><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.244271485687CD9E0389FF.png?w=640\" data-recalc-dims=\"1\" \/> <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile5.uf.227F4D505687CD9E2913FE.png?w=640\" data-recalc-dims=\"1\" \/> <\/P><\/LI><br \/>\n<LI><br \/>\n<DIV>Shrink <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc218\ud589<\/SPAN> <\/DIV><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.262735475687CDA01844C5.png?w=640\" data-recalc-dims=\"1\" \/> <\/P><\/LI><br \/>\n<LI><br \/>\n<DIV>Shrink <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc815\uc0c1\uc801\uc73c\ub85c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc218\ud589\ub41c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uac83<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud655\uc778<\/SPAN>. <\/DIV><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile27.uf.230400495687CDA028A8FB.png?w=640\" data-recalc-dims=\"1\" \/> <\/P><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Database 9i\uae4c\uc9c0\ub294 \uc138\uadf8\uba3c\ud2b8 HWM\uc774\ud558\uc5d0 \ud560\ub2f9\ub41c \uacf5\uac04\uc740 \uc624\uc9c1 \uc138\uadf8\uba3c\ud2b8\ub97c \uc774\uad00\ud558\uac70\ub098 \uc7ac \uc815\uc758\ud560 \ub54c \ubc18\ub0a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4. Oracle Database 10g\ubd80\ud130\ub294 \uc138\uadf8\uba3c\ud2b8\uc758 \ube48 \uacf5\uac04\uc744 shrink \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc138\uadf8\uba3c\ud2b8\uac00 shrink \ub420 \ub54c, \uadf8 \ub370\uc774\ud130\ub294 \uc9d1\uc57d\ub418\uace0 HWM \uc815\ubcf4\ub3c4 \ubcc0\uacbd\ub429\ub2c8\ub2e4. \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \uacf5\uac04\uc740 \uc138\uadf8\uba3c\ud2b8\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ubc18\ub0a9\ub418\uc5b4 \uc9d1\ub2c8\ub2e4. &nbsp; &nbsp; CTAS ,ITAS \ub97c \uc774\uc6a9\ud574 Table \uc0dd\uc131 &nbsp; &nbsp; &nbsp; &nbsp; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1072,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[11],"tags":[569,429,570,571,572],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.244271485687CD9E0389FF.png?fit=226%2C84","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1071"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1071"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1072"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1071"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}