{"id":389,"date":"2015-06-29T10:14:31","date_gmt":"2015-06-29T10:14:31","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=389"},"modified":"2015-06-29T10:14:31","modified_gmt":"2015-06-29T10:14:31","slug":"interval-%ed%8c%8c%ed%8b%b0%ec%85%94%eb%8b%9d%ec%97%90-%eb%8c%80%ed%95%9c-%ec%9d%b4%ed%95%b411g-newfeture","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=389","title":{"rendered":"Interval \ud30c\ud2f0\uc154\ub2dd\uc5d0 \ub300\ud55c \uc774\ud574(11g Newfeture)"},"content":{"rendered":"
    \n
  1. Range \ud30c\ud2f0\uc154\ub2dd\uc744 \uc774\uc6a9\ud560 \ub54c, \uc815\uc758\ub418\uc9c0 \uc54a\uc740 \ud30c\ud2f0\uc158\uc5d0 \ub300\ud574\uc11c insert\uc2dc \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.
    \n<\/span><\/li>\n<\/ol>\n

     
    \n <\/p>\n

    create table sales6
    \n<\/span><\/p>\n

    (
    \n<\/span><\/p>\n

    sales_id number,
    \n<\/span><\/p>\n

    sales_dt date
    \n<\/span><\/p>\n

    )
    \n<\/span><\/p>\n

    partition by range (sales_dt)
    \n<\/span><\/p>\n

    (
    \n<\/span><\/p>\n

    partition p0701 values less than (to_date(‘2014-02-01′,’yyyy-mm-dd’)),
    \n<\/span><\/p>\n

    partition p0702 values less than (to_date(‘2014-03-01′,’yyyy-mm-dd’))
    \n<\/span><\/p>\n

    );
    \n<\/span><\/p>\n

     
    \n <\/p>\n

    \uc544\ub798\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.
    \n<\/span><\/p>\n


    \n\t\t<\/span><\/p>\n

     
    \n <\/p>\n

    \uc774\ub7f0 \uc0c1\ud669\uc744 \ubc29\uc9c0 \ud558\uae30 \uc704\ud574\uc11c\ub294 Range \ud30c\ud2f0\uc158\uc758 \uacbd\uc6b0 insert \ud558\uae30 \uc804\uc5d0 \ubbf8\ub9ac \ud30c\ud2f0\uc158\uc744 \uc815\uc758 \ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.
    \n<\/span><\/p>\n

       2. Interval \ud30c\ud2f0\uc154\ub2dd\uc758 \uacbd\uc6b0 \ubbf8\ub9ac \ud30c\ud2f0\uc154\ub2dd\uc744 \uc815\uc758\ud558\uc9c0 \uc54a\uc544\ub3c4 \uc815\ud574\uc9c4 \uc870\uac74\uc5d0 \uc758\ud574 \ud574\ub2f9 \ub808\ucf54\ub4dc insert\uc2dc \ud30c\ud2f0\uc158\uc774 \uc790\ub3d9\uc0dd\uc131 \ub429\ub2c8\ub2e4.(11g NewFeature)<\/strong>  <\/span><\/p>\n

    create table sales7
    \n<\/span><\/p>\n

    (
    \n<\/span><\/p>\n

    sales_id number,
    \n<\/span><\/p>\n

    sales_dt date
    \n<\/span><\/p>\n

    )
    \n<\/span><\/p>\n

    partition by range (sales_dt)
    \n<\/span><\/p>\n

    interval (numtoyminterval(1,’MONTH’))
    \n<\/span><\/p>\n

    (
    \n<\/span><\/p>\n

    partition p0701 values less than (to_date(‘2014-02-01′,’yyyy-mm-dd’))
    \n<\/span><\/p>\n

    );
    \n<\/span><\/p>\n

     
    \n <\/p>\n

    \ud604\uc7ac \ud30c\ud2f0\uc158 \uc815\uc758 \ub0b4\uc6a9
    \n<\/span><\/p>\n


    \n\t\t<\/span><\/p>\n

     
    \n <\/p>\n

    2014-03-01\uc73c\ub85c insert \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
    \n<\/span><\/p>\n

    SQL> insert into sales7 values(1,to_date(‘2014-03-01′,’yyyy-mm-dd’));
    \n<\/span><\/p>\n

     
    \n <\/p>\n

    \uc790\ub3d9\uc73c\ub85c \ud30c\ud2f0\uc158\ub124\uc784\uc774 \uc9c0\uc815\ub418\uace0 \ud30c\ud2f0\uc158 \uc815\uc758\uac00 \ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
    \n<\/span><\/p>\n


    \n\t\t<\/span><\/p>\n

     
    \n <\/p>\n

     
    \n <\/p>\n

    insert\ub418\ub294 \ub808\ucf54\ub4dc\uc5d0 \ub530\ub77c \uc790\ub3d9\uc73c\ub85c \ud30c\ud2f0\uc158\uc774 \ub9cc\ub4e4\uc5b4\uc9c0\uae30 \ub54c\ubb38\uc5d0 \ud30c\ud2f0\uc158\uc774 \uc5c6\uc5b4 \uc5d0\ub7ec\uac00 \ub098\ub294 \uc0c1\ud669\uc744 \ubbf8\uc5f0\uc5d0 \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
    \n<\/span><\/p>\n

     
    \n <\/p>\n

      \n
    1. \n
      Tablespace \uc9c0\uc815.
      \n<\/span><\/div>\n

      \ud30c\ud2f0\uc154\ub2dd \uc0dd\uc131 \uad6c\ubb38 \uc911 interval \ub2e4\uc74c\uc5d0 \uc544\ub798 \uad6c\ubb38\uc744 \ub123\uc5b4\uc90d\ub2c8\ub2e4.
      \n<\/span><\/p>\n

       
      \n <\/p>\n

      interval (numtoyminterval(1,’MONTH’))
      \n<\/span><\/p>\n

      store in (TS1,TS2,TS3)
      \n<\/span><\/p>\n

       
      \n <\/p>\n

      TS1, TS2, TS3 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud574 round-robin\ubc29\uc2dd\uc73c\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4.
      \n<\/span><\/p>\n<\/li>\n<\/ol>\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      Range \ud30c\ud2f0\uc154\ub2dd\uc744 \uc774\uc6a9\ud560 \ub54c, \uc815\uc758\ub418\uc9c0 \uc54a\uc740 \ud30c\ud2f0\uc158\uc5d0 \ub300\ud574\uc11c insert\uc2dc \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.     create table sales6 ( sales_id number, sales_dt date ) partition by range (sales_dt) ( partition p0701 values less than (to_date(‘2014-02-01′,’yyyy-mm-dd’)), partition p0702 values less than (to_date(‘2014-03-01′,’yyyy-mm-dd’)) );     \uc544\ub798\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.     \uc774\ub7f0 \uc0c1\ud669\uc744 \ubc29\uc9c0 \ud558\uae30 \uc704\ud574\uc11c\ub294 Range \ud30c\ud2f0\uc158\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":390,"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":[96,97,98,99],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.22758A3455911A852B5A27.png?fit=576%2C77","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/389"}],"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=389"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/389\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/390"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=389"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}