{"id":3238,"date":"2018-02-04T09:06:57","date_gmt":"2018-02-04T00:06:57","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3238"},"modified":"2018-02-04T09:06:57","modified_gmt":"2018-02-04T00:06:57","slug":"window-oracle-cmd-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%ec%95%84%ec%b9%b4%ec%9d%b4%eb%b8%8c-%ed%8c%8c%ec%9d%bc-%ec%82%ad%ec%a0%9c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3238","title":{"rendered":"[Window Oracle] cmd \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud55c \uc544\uce74\uc774\ube0c \ud30c\uc77c \uc0ad\uc81c"},"content":{"rendered":"<p>windows os \uc758 oracle \ud658\uacbd\uc5d0\uc11c<\/p>\n<p>cmd \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud55c \uc544\uce74\uc774\ube0c \ud30c\uc77c \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95 \uc785\ub2c8\ub2e4.<\/p>\n<p>\uc544\uce74\uc774\ube0c \uc0ad\uc81c \ud30c\uc77c \uc2e4\ud589 \uc2a4\ud06c\ub9bd\ud2b8<\/p>\n<p>&#8212;\u00a0 deloldfile.cmd<\/p>\n<pre class=\"theme:terminal lang:vb decode:true\">@echo off\r\n\r\nREM \u2198 \uc9c0\uc2dd\ud30c\uc77c \uc124\uba85 \r\nREM \uc708\ub3c4\uc6b0\uc988\uc5d0\uc11c \ud2b9\uc815 \ub0a0\uc9dc \uc774\uc804\uc5d0 \uc0dd\uc131\ub41c \ub514\ub809\ud1a0\ub9ac\ub97c \uc0ad\uc81c\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8\uc785\ub2c8\ub2e4.\r\nREM (\uc0ac\uc6a9\uc608) delolddir.cmd [\ub514\ub809\ud1a0\ub9ac\uacbd\ub85c] [\uc0ad\uc81c\uc77c]\r\nREM C:\\logdir \ub514\ub809\ud1a0\ub9ac \ub0b4\uc5d0 30\uc77c \uc774\uc804\uc5d0 \uc0dd\uc131\ub41c \ub514\ub809\ud1a0\ub9ac\ub97c \uc0ad\uc81c\ud558\uace0\uc790 \ud55c\ub2e4\uba74..\r\nREM &gt; delolddir.cmd C:\\logdir -30\r\nREM (\uc8fc\uc7581: \uc704\uc640 \uac19\uc774 \uc2e4\ud589\ud560 \uacbd\uc6b0 C:\\logdir \ub514\ub809\ud1a0\ub9ac\uc758 \ud558\uc704 \ub514\ub809\ud1a0\ub9ac \uc911 30 \uc77c \uc774\uc804\uc5d0 \uc0dd\uc131\ub41c \ub514\ub809\ud1a0\ub9ac\ub294 \ubaa8\ub450 \uc0ad\uc81c\ub418\ub2c8 \uc8fc\uc758\ud558\uc154\uc11c \ud14c\uc2a4\ud2b8 \ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.)\r\nREM \r\nREM \u2198 \ud558\uace0\uc2f6\uc740 \ub9d0 | \ud64d\ubcf4\ubb38\uad6c, \ub9e4\ub274\uc5bc \r\nREM \uc8fc\uae30\uc801\uc73c\ub85c \ub85c\uadf8\ud654\uc77c\uc774 \uc0dd\uc131\ub418\ub294 \ub514\ub809\ud1a0\ub9ac\ub97c \uc77c\uc815\ub7c9\ub9cc \uc720\uc9c0 \uad00\ub9ac\ud558\uace0\uc790 \ud560 \ub54c \uc0ac\uc6a9\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\r\nREM \uc708\ub3c4\uc6b0\uc988 \uc608\uc57d\uc791\uc5c5\uc5d0 \ub4f1\ub85d\ud558\uc5ec \ud558\ub8e8\uc5d0 \ud55c\ubc88 \uc2e4\ud589\ub418\ub3c4\ub85d \ud558\uba74 \uc6d0\ud558\ub294 \ubd84\ub7c9\uc758 \ub514\ub809\ud1a0\ub9ac \ud654\uc77c\ub9cc \uc720\uc9c0\ud560 \uc218 \uc788\uaca0\uc8e0.. \r\n\r\nset vbfile=_delolddir.vbs\r\n\r\necho Option Explicit &gt; %vbfile%\r\necho Dim objFS, objRoot, objArgs &gt;&gt; %vbfile%\r\necho Dim szRoot, szMsg, targetDiff &gt;&gt; %vbfile%\r\necho Dim nRetVal &gt;&gt; %vbfile%\r\n\r\necho set objFS = CreateObject( \"Scripting.FileSystemObject\" ) &gt;&gt; %vbfile%\r\necho set objArgs = Wscript.Arguments &gt;&gt; %vbfile%\r\n\r\necho If objArgs.Count ^&gt;= 2 Then &gt;&gt; %vbfile%\r\necho \tszRoot = objArgs.Item(0) &gt;&gt; %vbfile%\r\necho \ttargetDiff = objArgs.Item(1) &gt;&gt; %vbfile%\r\necho Else  &gt;&gt; %vbfile%\r\necho\tszMsg = \"\uc9c0\uc6b8 \ud30c\uc77c\uc774 \uc788\ub294 \ub514\ub809\ud1a0\ub9ac\uba85\uacfc \uc0ad\uc81c\uc77c\uc744 \uc9c0\uc815\ud574\uc8fc\uc9c0 \uc54a\uc558\uc2b5\ub2c8\ub2e4.\" &gt;&gt; %vbfile%\r\necho \tszMsg = szMsg ^&amp; \" \ub9cc\uc57d 3\uc77c \uc774\uc804(\uc815\ud655\ud788 3\uc77c\uc9f8 \ud30c\uc77c \uc81c\uc678) \ud30c\uc77c\uc744 \uc0ad\uc81c\ud558\ub824\uba74 -3 \uc744 \uc785\ub825\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.\" &gt;&gt; %vbfile%\r\necho\tszMsg = szMsg ^&amp; \" \uc2e4\uc81c\ub85c \uc0ad\uc81c\ub418\ub2c8 \ucda9\ubd84\ud788 \ud14c\uc2a4\ud2b8 \ud55c \ud6c4 \uc0ac\uc6a9\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. (\uc815\ub9d0 \uc8fc\uc758 \ubc14\ub78c \ubcf5\uad6c \uc548\ub428)\" &gt;&gt; %vbfile%\r\necho\tWscript.Echo szMsg &gt;&gt; %vbfile%\r\necho\tWscript.Quit &gt;&gt; %vbfile%\r\necho End If &gt;&gt; %vbfile%\r\n\r\necho If objFS.FolderExists( szRoot ) then &gt;&gt; %vbfile%\r\necho  Dim objFolder &gt;&gt; %vbfile%\r\necho  Dim objFiles &gt;&gt; %vbfile%\r\necho  Dim objFile &gt;&gt; %vbfile%\r\necho \tset objFolder = objFS.GetFolder( szRoot ) &gt;&gt; %vbfile%\r\necho  set objFiles = objFolder.files &gt;&gt; %vbfile%\r\n\r\necho \tFor each objFile in objFiles &gt;&gt; %vbfile%\r\necho \t\tif IsObject( objFile ) Then &gt;&gt; %vbfile%\r\necho \t\t\tnRetVal = DisplayFile( objFile ) &gt;&gt; %vbfile%\r\necho \t\tend If &gt;&gt; %vbfile%\r\necho \tNext &gt;&gt; %vbfile%\r\n\r\necho End If &gt;&gt; %vbfile%\r\n\r\necho Function DisplayFile( objFile1 ) &gt;&gt; %vbfile%\r\nREM echo \t If DateDiff(\"d\", Now, CDate(objFile1.DateCreated)) ^&lt; Int(targetDiff) Then &gt;&gt; %vbfile%\r\necho \t If DateDiff(\"d\", Now, CDate(objFile1.DateLastModified)) ^&lt; Int(targetDiff) Then &gt;&gt; %vbfile%\r\necho \t   'Wscript.Echo objFile1.Name &gt;&gt; %vbfile%\r\necho     objFile1.Delete &gt;&gt; %vbfile%\r\necho \t End If &gt;&gt; %vbfile%\r\necho End Function &gt;&gt; %vbfile%\r\n\r\ncscript \/\/NoLogo \/\/T:10 %vbfile% %1 %2\r\n\r\ndel %vbfile%\r\n\r\n@echo on\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>\uc774 \uc218\ud589 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\ud589 \uc2dc\ud0ac \uc2a4\ud06c\ub9bd\ud2b8<\/p>\n<p>&#8212; delfile.cmd \ud30c\uc77c \ub0b4\uc6a9<\/p>\n<pre class=\"theme:terminal lang:vb decode:true\">call D:\\\uc791\uc5c5\\ppp\\deloldfile.cmd c:\\test -3<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>windows os \uc758 oracle \ud658\uacbd\uc5d0\uc11c cmd \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud55c \uc544\uce74\uc774\ube0c \ud30c\uc77c \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95 \uc785\ub2c8\ub2e4. \uc544\uce74\uc774\ube0c \uc0ad\uc81c \ud30c\uc77c \uc2e4\ud589 \uc2a4\ud06c\ub9bd\ud2b8 &#8212;\u00a0 deloldfile.cmd @echo off REM \u2198 \uc9c0\uc2dd\ud30c\uc77c \uc124\uba85 REM \uc708\ub3c4\uc6b0\uc988\uc5d0\uc11c \ud2b9\uc815 \ub0a0\uc9dc \uc774\uc804\uc5d0 \uc0dd\uc131\ub41c \ub514\ub809\ud1a0\ub9ac\ub97c \uc0ad\uc81c\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8\uc785\ub2c8\ub2e4. REM (\uc0ac\uc6a9\uc608) delolddir.cmd [\ub514\ub809\ud1a0\ub9ac\uacbd\ub85c] [\uc0ad\uc81c\uc77c] REM C:\\logdir \ub514\ub809\ud1a0\ub9ac \ub0b4\uc5d0 30\uc77c \uc774\uc804\uc5d0 \uc0dd\uc131\ub41c \ub514\ub809\ud1a0\ub9ac\ub97c \uc0ad\uc81c\ud558\uace0\uc790 \ud55c\ub2e4\uba74.. REM &gt; delolddir.cmd C:\\logdir -30 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2862,"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":[9],"tags":[558,436,437,908,684],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/managed-services2.jpg?fit=1200%2C386","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3238"}],"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=3238"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3238\/revisions"}],"predecessor-version":[{"id":3239,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3238\/revisions\/3239"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2862"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3238"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}