{"id":1100,"date":"2016-01-02T13:20:35","date_gmt":"2016-01-02T13:20:35","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1100"},"modified":"2016-01-02T13:20:35","modified_gmt":"2016-01-02T13:20:35","slug":"tablespace-%ec%83%9d%ec%84%b1-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8-%ec%b6%94%ec%b6%9c%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1100","title":{"rendered":"Tablespace \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8 \ucd94\ucd9c\ud558\uae30"},"content":{"rendered":"<p><P><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ucc28\uc138\ub300\ub098 \uac1c\ubc1cDB \uad6c\ucd95\uc2dc\uc5d0 \uae30\uc874\uc5d0 \uc788\ub358 \ud658\uacbd\uacfc \ub3d9\uc77c\ud558\uac8c \uad6c\ucd95\ud558\uace0\uc790 \ud560\ub54c \uc0ac\uc6a9 \ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uac04\ub2e8\ud55c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ucffc\ub9ac\ub97c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc774\uc6a9\ud574\uc11c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ucd94\ucd9c\uc744<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud560<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc218<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc788\uc2b5\ub2c8\ub2e4<\/SPAN>. <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P>Set pages 500 <\/P><br \/>\n<P>Set line 500 <\/P><br \/>\n<P>Set long 20000000 <\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">select tablespace_name, dbms_metadata.get_ddl(&#8216;TABLESPACE&#8217;,tablespace_name)||&#8217;;&#8217; script <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">from dba_tablespaces <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">where tablespace_name in (&#8216;TEMP&#8217;,&#8217;USERS&#8217;,&#8217;UNDOTBS1&#8242;,&#8217;SYSTEM&#8217;,&#8217;SYSAUX&#8217;);<\/SPAN> &#8212; <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud3ec\ud568<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc2dc\ud0ac<\/SPAN> Tablespace <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uae30\uc785<\/SPAN> <\/SPAN><\/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\/cfile7.uf.21225D495687CEA20F1437.png?w=640\" data-recalc-dims=\"1\" \/> <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ucc28\uc138\ub300\ub098 \uac1c\ubc1cDB \uad6c\ucd95\uc2dc\uc5d0 \uae30\uc874\uc5d0 \uc788\ub358 \ud658\uacbd\uacfc \ub3d9\uc77c\ud558\uac8c \uad6c\ucd95\ud558\uace0\uc790 \ud560\ub54c \uc0ac\uc6a9 \ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. &nbsp; &nbsp; \uac04\ub2e8\ud55c \ucffc\ub9ac\ub97c \uc774\uc6a9\ud574\uc11c \ucd94\ucd9c\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. &nbsp; &nbsp; Set pages 500 Set line 500 Set long 20000000 select tablespace_name, dbms_metadata.get_ddl(&#8216;TABLESPACE&#8217;,tablespace_name)||&#8217;;&#8217; script from dba_tablespaces where tablespace_name in (&#8216;TEMP&#8217;,&#8217;USERS&#8217;,&#8217;UNDOTBS1&#8242;,&#8217;SYSTEM&#8217;,&#8217;SYSAUX&#8217;); &#8212; \ud3ec\ud568 \uc2dc\ud0ac Tablespace \uae30\uc785 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":1101,"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":[3],"tags":[606,607,89,327,608],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.21225D495687CEA20F1437.png?fit=898%2C665","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1100"}],"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=1100"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1100\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1101"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1100"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}