{"id":1302,"date":"2016-03-23T07:40:39","date_gmt":"2016-03-23T07:40:39","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1302"},"modified":"2016-03-23T07:40:39","modified_gmt":"2016-03-23T07:40:39","slug":"oracle-partition-table-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1302","title":{"rendered":"Oracle Partition Table \uc815\ub9ac"},"content":{"rendered":"

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

\n

Version 7
\n<\/span><\/h3>\n<\/p>\n

Partitioning\uc740 partition view\ub97c \ud1b5\ud574 V7.3\ubd80\ud130 \uac00\ub2a5\ud558\uc600\ub2e4. \uc774 view\ub294 \ub3d9\uc77c\ud55c \uad6c\uc870\ub97c \uac00\uc9c0\ub294 table\uc758 UNION ALL\uc5d0 \uae30\ubcf8\uc744 \ub450\uc5c8\uace0 column\uacfc type\uc774 \ub3d9\uc77c\ud558\uace0 \uac19\uc740 \uc21c\uc11c\ub97c \uac00\uc838\uc57c \ud55c\ub2e4. \ub354\uc6b1\uc774 \uac01 table\uc740 partition key\uc5d0 \ud574\ub2f9\ud558\ub294 index\ub97c \uac00\uc838\uc57c \ud55c\ub2e4. \uc870\uac74\uc744 \ub9cc\uc871\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc5d0\ub294 optimizer\uac00 execution plan\uc744 \uc138\uc6b8 \ub54c \uc2e4\ud328\ud558\uac8c \ub41c\ub2e4.
\n<\/span><\/p>\n

\n

Partition View
\n<\/span><\/h4>\n<\/p>\n

table\uc758 UNION ALL view\ub85c \uc0dd\uc131\ub41c\ub2e4<\/span><\/p>\n

Create view partitioned_emp as
\n<\/span><\/p>\n

select * from emp1
\n<\/span><\/p>\n

union all
\n<\/span><\/p>\n

select * from emp2
\n<\/span><\/p>\n

union all
\n<\/span><\/p>\n

select * from emp3;
\n<\/span><\/p>\n


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

Parameter “PARTITION_VIEW_ENABLED” \ub97c “TRUE”\ub85c \uc124\uc815\ud558\uba74 optimizer\uac00 partition view \ub97c \uc778\uc2dd\ud558\uac8c \ub41c\ub2e4.
\n<\/span><\/p>\n

\n

\ub2e8\uc810
\n<\/span><\/h4>\n<\/p>\n
    \n
  1. \n
    DDL, DML\uc758 \uc21c\uc11c\uac00 \uace0\ub824\ub418\uc9c0 \uc54a\ub294\ub2e4.
    \n<\/span><\/div>\n<\/li>\n
  2. \n
    Export, import, loader\uc640 \uac19\uc740 \ud234\uc5d0\uc11c \uace0\ub824\ub418\uc9c0 \uc54a\ub294\ub2e4.
    \n<\/span><\/div>\n<\/li>\n
  3. \n
    Global index\uc758 \uc0ac\uc6a9\uc774 \ubd88\uac00\ub2a5\ud558\ub2e4.
    \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

    \n

    Version 8
    \n<\/span><\/h3>\n<\/p>\n

    Partitioning\uc740 Oracle V8 Enterprise Server Edition\uc758 option\uc73c\ub85c \uc81c\uacf5\ub41c\ub2e4. VLDB\ud658\uacbd\uc5d0\uc11c \uc131\ub2a5, DB\uad00\ub9ac\ub4f1\uc5d0\uc11c \uc720\uc6a9\ud558\ub2e4. Historical data\uc640 \uad00\uacc4\ub41c Database\ub098 \uc131\ub2a5\uacfc \uc720\uc6a9\uc131\uc5d0 \uace0\ubbfc\ud558\ub294 OLTP database\ub294 \uc774 option\uc744 \ud544\uc694\ub85c \ud55c\ub2e4.
    \n<\/span><\/p>\n

    \n

    \uc7a5\uc810
    \n<\/span><\/h4>\n<\/p>\n
      \n
    1. \n
      Table\uc774\ub098 index \ub97c partition level\uc5d0\uc11c \uad00\ub9ac\ud560 \uc218 \uc788\uace0 partition\ub4e4 \uac04\uc758 \ub3c5\ub9bd\uc131\uc740 \ub3d9\uc2dc\uc5d0 \ub9ce\uc740 partition\ub4e4\uc744 \uc720\uc9c0\ubcf4\uc218 \ud560 \uc218 \uc788\uac8c \ud55c\ub2e4.
      \n<\/span><\/div>\n<\/li>\n
    2. \n
      Database\uc758 \uc0ac\uc6a9\uc911\uc9c0 \uc2dc\uac04\uc774 \uac10\uc18c\ud55c\ub2e4. recovery\ub294 partition level\uc5d0\uc11c \uc218\ud589\ub41c\ub2e4.
      \n<\/span><\/div>\n<\/li>\n
    3. \n
      \uc5ec\ub7ec partition\uc744 \uc11c\ub85c \ub2e4\ub978 disk\uc0c1\uc5d0 \ud3bc\uccd0\ub193\uc544 \ubcf4\ub2e4 \ub098\uc740 \ub370\uc774\ud0c0\uc758 \ubd84\uc0b0\uc744 \uc774\ub8f0 \uc218 \uc788\ub2e4.
      \n<\/span><\/div>\n<\/li>\n
    4. \n
      \ud2b9\ud788 data warehousing \ub098 decision making \uc2dc\uc2a4\ud15c\uc5d0\uc11c query\uc758 \uc131\ub2a5 \ud5a5\uc0c1\uc774 \uc788\ub2e4. optimizer\ub294 query\uc5d0 \uae30\uc220\ub41c \ud558\ub098 \ub610\ub294 \uadf8 \uc774\uc0c1\uc758 partition\uacfc \uad00\ub828\ub41c \uc81c\ud55c\ub41c \uc591\ub9cc\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc774 \uc788\ub2e4.
      \n<\/span><\/div>\n<\/li>\n<\/ol>\n

      \n

      \uc81c\uc57d\uc0ac\ud56d
      \n<\/span><\/h4>\n<\/p>\n
        \n
      1. \n
        Table\uacfc index\uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5\ud558\uc9c0\ub9cc cluster\uc5d0\uc11c\ub294 \ubd88\uac00
        \n<\/span><\/div>\n<\/li>\n
      2. \n
        RULE-based optimizer\ub294 table\uacfc index\uc758 partition\uc744 \uace0\ub824\ud558\uc9c0 \uc54a\ub294\ub2e4.
        \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

        \n

        Version 8i
        \n<\/span><\/h3>\n<\/p>\n

        Oracle V8i \uc5d0\uc11c\ub294 V8\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub358 Range partition\uc758 \uae30\ub2a5\ud5a5\uc0c1\uacfc Hash, Composite Partition\uae30\ub2a5\uc774 \ucd94\uac00 \ub418\uc5c8\ub2e4. \ub610 LOB\uc744 \ud3ec\ud568\ud558\ub294 table, IOT, Object table\uc5d0 \ub300\ud55c partition\ub3c4 \uac00\ub2a5\ud558\uac8c \ub418\uc5c8\ub2e4.
        \n<\/span><\/p>\n


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

        \n

        Version 9i
        \n<\/span><\/h3>\n<\/p>\n

        Oracle V9i\uc5d0\uc11c\ub294 LIST partition\uc774 \ucd94\uac00\ub418\uc5c8\ub2e4. List partition\uc740 \uc0ac\uc6a9\uc790\uac00 partition\uc5d0 \ub4e4\uc5b4\uac08 row\ub97c \uba85\uc2dc\uc801\uc73c\ub85c \uc81c\uc5b4\ud560 \uc218 \uc788\uac8c \ud55c\ub2e4. \uc0ac\uc6a9\uc790\ub294 \uac01 partition\uc758 Key\ub97c \uc704\ud55c \ube44 \uc5f0\uc18d\uc801\uc778 \uac12\uc744 \uc815\uc758\ud55c\ub2e4. \uc774 \ubc29\ubc95\uc740 partition\uacfc \uad00\ub828\ub41c \uac12\uc758 \ubc94\uc704\ub97c \uc0ac\uc6a9\ud558\ub294 Range partition\uc774\ub098, Hash function\uc744 \uc0ac\uc6a9\ud558\ub294 Hash Partition\uacfc\ub294 \ub2e4\ub974\ub2e4.
        \n<\/span><\/p>\n

        \uc7a5\uc810 : \uc790\uc5f0\uc2a4\ub7f0 \ubc29\ubc95\uc73c\ub85c Data\ub97c \ube44\uc21c\uc11c\uc801\uc774\uace0 \uad00\uacc4\uc5c6\ub294 \uc9d1\ud569\uc73c\ub85c \ubd84\ub958\ud560 \uc218 \uc788\ub2e4.
        \n<\/span><\/p>\n

        \ub2e8\uc810 : Partition Key\ub294 \uc624\uc9c1 \ud558\ub098\uc758 Column\ub9cc \uad6c\uc131\ud560 \uc218 \uc788\ub2e4.
        \n<\/span><\/p>\n


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

        \n

        Partition\uc758 \uc885\ub958
        \n<\/span><\/h2>\n<\/p>\n

        Range-type, Hash-type, Composite-type Partition \uc744 \uc0b4\ud3b4\ubcf8\ub2e4.
        \n<\/span><\/p>\n


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

        \n

        Range-type partition
        \n<\/span><\/h3>\n<\/p>\n

        Table\uacfc Index\uc758 partition\uc744 column\uc758 \ubc94\uc704\uc5d0 \uae30\ubc18\uc744 \ub450\uace0 \uc788\ub2e4.
        \n<\/span><\/p>\n

        <\/p>\n

        CREATE TABLE emp_range (
        \n<\/span><\/p>\n

        empno NUMBER(4) NOT NULL,
        \n<\/span><\/p>\n

        ename VARCHAR2(10),
        \n<\/span><\/p>\n

        sal NUMBER(7,2)
        \n<\/span><\/p>\n

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

        PARTITION BY RANGE(EMPNO)
        \n<\/span><\/p>\n

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

        partition emp_p1 VALUES LESS THAN (50),
        \n<\/span><\/p>\n

        partition emp_p2 VALUES LESS THAN (100),
        \n<\/span><\/p>\n

        partition emp_p3 VALUES LESS THAN (150),
        \n<\/span><\/p>\n

        partition emp_p4 VALUES LESS THAN (MAXVALUE)
        \n<\/span><\/p>\n

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

        \uac01 partition\uc5d0\ub294 \uc0c1\uc704 \uac12\uc774 \uc815\uc758\ub41c\ub2e4. \uac01 \uac12\uc758 \uc800\uc7a5\uc704\uce58\ub294 partition key\uc640\uc758 \ube44\uad50\uc5d0 \uc758\ud574 \uacb0\uc815\ub418\uba70 \uc0c1\uc704 \uac12\uc740 \ud3ec\ud568\ub418\uc9c0 \uc54a\ub294\ub2e4.
        \n<\/span><\/p>\n

        ‘VALUE LESS THAN (value1, value2 …, valueN)’ \uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5\ud55c function\uc740 TO_CHAR\uacfc RPAD\uc774\ub2e4.
        \n<\/span><\/p>\n

        \n

        Null\uc758 \ucc98\ub9ac
        \n<\/span><\/h4>\n<\/p>\n

        Partition Key\uc758 NULL\uac12\uc740 partition key\ub85c \uc0ac\uc6a9\ub420 \uc218 \uc788\uace0 MAXVALUE\ub97c \uc81c\uc678\ud55c \uc5b4\ub5a0\ud55c \uac12\ubcf4\ub2e4 \uc0c1\uc704\ub85c \uac04\uc8fc\ud55c\ub2e4. NULL\uac12\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc0c1\uc704 partition\uc758 \ucd5c\uc0c1\uc704 \uac12\uc744 MAXVALUE\ub85c \uc9c0\uc815\ud574\uc57c \ud558\uace0 \uadf8\ub807\uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc5d0\ub294 ORA-14400 error\uac00 \ubc1c\uc0dd\ud55c\ub2e4. \uc989, NULL\uc740 MAXVALUE\uac00 \uc9c0\uc815\ub41c \uacbd\uc6b0 \uc0c1\uc704 partition\uc5d0 \uc800\uc7a5\ub418\uace0 \uadf8\ub807\uc9c0 \uc54a\uc740 \uacbd\uc6b0 ORA-14400\uc774 \ubc1c\uc0dd\ud55c\ub2e4.
        \n<\/span><\/p>\n

        \n

        Partition\uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub294 View
        \n<\/span><\/h4>\n<\/p>\n
        \n\n\n\n<\/colgroup>\n\n\n
        \n

        DBA_PART_KEY_COLUMNS
        \n<\/span><\/p>\n

        DBA_PART_TABLES
        \n<\/span><\/p>\n

        DBA_TAB_PARTITIONS
        \n<\/span><\/p>\n

        DBA_PART_COL_STATISTICS
        \n<\/span><\/p>\n

        DBA_PART_HISTOGRAMS
        \n<\/span><\/p>\n

        DBA_PART_INDEXES
        \n<\/span><\/p>\n

        DBA_IND_PARTITIONS
        \n<\/span><\/p>\n

        DBA_PART_LOBS
        \n<\/span><\/p>\n

        DBA_LOB_PARTITIONS<\/span><\/p>\n<\/td>\n

        		\n

        partition\ub41c Object\uc758 Partition Key \uc815\ubcf4
        \n<\/span><\/p>\n

        partition table\uc758 partition \uc815\ubcf4
        \n<\/span><\/p>\n

        partition table\uc758 partition, storage, \ud1b5\uacc4 \uc815\ubcf4
        \n<\/span><\/p>\n

        table partition\uc5d0 \uad00\ud55c column\uc758 \ud1b5\uacc4, \ubd84\ud3ec \uc815\ubcf4
        \n<\/span><\/p>\n

        partition table\uc758 \uc2e4\uc81c \ubd84\ud3ec \uc815\ubcf4
        \n<\/span><\/p>\n

        partition index\uc758 partition \uc815\ubcf4
        \n<\/span><\/p>\n

        partition index\uc758 partition, storage, \ud1b5\uacc4 \uc815\ubcf4
        \n<\/span><\/p>\n

        LOB part\uc758 \uc815\ubcf4\uc640 LOB data part\uc758 \uc18d\uc131
        \n<\/span><\/p>\n

        LOB partition \uc758 partition, storage \uc815\ubcf4<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n


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


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


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


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

        \n

        Hash-type partition
        \n<\/span><\/h3>\n<\/p>\n

        Oracle\uc5d0 \uc758\ud574 \uc81c\uacf5\ub418\ub294 hashing function\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubcf4\ub2e4 \ub098\uc740 data\uc758 \ubd84\uc0b0\uc744 \uac00\ub2a5\ud558\uac8c \ud55c\ub2e4.
        \n<\/span><\/p>\n

        CREATE TABLE emp_hpart (
        \n<\/span><\/p>\n

        empno NUMBER(4) NOT NULL,
        \n<\/span><\/p>\n

        ename VARCHAR2(10),
        \n<\/span><\/p>\n

        sal NUMBER(7,2)
        \n<\/span><\/p>\n

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

        STORAGE (INITIAL 50k NEXT 50k)
        \n<\/span><\/p>\n

        PARTITION BY HASH(sal)
        \n<\/span><\/p>\n

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

        PARTITION H1 TABLESPACE data01,
        \n<\/span><\/p>\n

        PARTITION H2 TABLESPACE data02,
        \n<\/span><\/p>\n

        PARTITION H3 TABLESPACE data03,
        \n<\/span><\/p>\n

        PARTITION H4 TABLESPACE data04
        \n<\/span><\/p>\n

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

        \n

        Hash type\uc758 partition\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uc758 \uc608
        \n<\/span><\/h4>\n<\/p>\n
          \n
        1. \n
          data\uc758 \ubd84\uc0b0\uc744 \uc704\ud55c \uae30\uc900\uc744 \ucc3e\ub294 \uac83\uc774 \ubd88\uac00\ub2a5\ud558\ub2e4.
          \n<\/span><\/div>\n<\/li>\n
        2. \n
          partition\uc744 \uc704\ud55c data \uc591\uc758 \uc608\uc0c1\uc774 \uc5b4\ub835\ub2e4.
          \n<\/span><\/div>\n<\/li>\n
        3. \n
          \uac01 partition\uac04\uc758 \uade0\ud615\uc744 \ub9de\ucd94\uae30\uac00 \uc5b4\ub835\ub2e4.
          \n<\/span><\/div>\n<\/li>\n<\/ol>\n

          \n

          \uc81c\uc57d \uc0ac\ud56d
          \n<\/span><\/h4>\n<\/p>\n
            \n
          1. \n
            \uc774 partition \ubc29\ubc95\uc740 \ub2e4\ub978 partition\uc0c1\uc5d0 data\uc758 \uade0\uc77c\ud55c \ubd84\ubc30\ub97c \uc704\ud574 2\uc758 \uc81c\uacf1\uc758 \uc218\uac00 \ud560\ub2f9\ub420 \uc218 \uc788\ub294 partition\uc774 \ud544\uc694\ud558\ub2e4.
            \n<\/span><\/div>\n<\/li>\n
          2. \n
            \uac01 partition\uc744 \uc704\ud55c \uc0c1\uc138\ud55c storage\uc808\uc740 \uae30\uc220\ud560 \uc218 \uc5c6\ub2e4. \uc774 \uc808\uc740 partition\uc774 \uc874\uc7ac\ud558\ub294 tablespace\ub85c\ubd80\ud130 \uc0c1\uc18d\ub41c\ub2e4.
            \n<\/span><\/div>\n<\/li>\n
          3. \n
            Hash partition\uc758 \uad00\ub9ac\ub294 SPLIT, MERGE\ub97c \uc81c\uc678\ud558\uba74 Range\uc640 \uc720\uc0ac\ud558\uba70 ADD, COALESCE \uba85\ub839\uc5b4\ub294 partition\uc758 add, drop\uc2dc\uc5d0 \uc0ac\uc6a9\ub41c\ub2e4.
            \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

            \n

            Composite-type partition
            \n<\/span><\/h3>\n<\/p>\n

            \uc774 \ubc29\ubc95\uc740 Range-type, Hash-type \ub450 \uac00\uc9c0\ub97c \ud63c\ud569\ud55c \ud615\ud0dc\uc774\ub2e4. \uccab\ubc88\uc9f8 level\uc740 Range, \ub450 \ubc88\uc9f8\ub294 Hash\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \uc5bb\uc744 \uc218 \uc788\ub294 \uc7a5\uc810\uc740 \uccab\ubc88\uc9f8 level\uc5d0\uc11c\ub294 \ub17c\ub9ac\uc801\uc778 data\uc758 \uc815\ub82c, \ub450 \ubc88\uc9f8\ub294 partition\uac04\uc758 \uade0\ud615\uc774\ub2e4.
            \n<\/span><\/p>\n

            CREATE TABLE emp_composite (
            \n<\/span><\/p>\n

            empno NUMBER(4) NOT NULL,
            \n<\/span><\/p>\n

            ename VARCHAR2(10),
            \n<\/span><\/p>\n

            sal NUMBER(6))
            \n<\/span><\/p>\n

            STORAGE (INITIAL 12k NEXT 12k)
            \n<\/span><\/p>\n

            PARTITION BY RANGE(empno)
            \n<\/span><\/p>\n

            SUBPARTITION BY HASH(sal) SUBPARTITIONS 4
            \n<\/span><\/p>\n

            STORE IN (DATA01, DATA02, DATA03, DATA04)
            \n<\/span><\/p>\n

            ( PARTITION p1 VALUES LESS THAN (50),
            \n<\/span><\/p>\n

            PARTITION p2 VALUES LESS THAN (100),
            \n<\/span><\/p>\n

            PARTITION p3 VALUES LESS THAN (150),
            \n<\/span><\/p>\n

            PARTITION p4 VALUES LESS THAN (MAXVALUE));
            \n<\/span><\/p>\n


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

            CREATE TABLE sales_composite (
            \n<\/span><\/p>\n

            item INTEGER,
            \n<\/span><\/p>\n

            qty INTEGER,
            \n<\/span><\/p>\n

            store VARCHAR(30),
            \n<\/span><\/p>\n

            dept NUMBER,
            \n<\/span><\/p>\n

            sale_date DATE
            \n<\/span><\/p>\n

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

            PARTITION BY RANGE (sale_date)
            \n<\/span><\/p>\n

            SUBPARTITION BY HASH(item)
            \n<\/span><\/p>\n

            SUBPARTITIONS 8
            \n<\/span><\/p>\n

            STORE IN (tbs1, tbs2, tbs3, tbs4, tbs5, tbs6, tbs7, tbs8)
            \n<\/span><\/p>\n

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

            PARTITION q1_1997
            \n<\/span><\/p>\n

            VALUES LESS THAN (TO_DATE(’01-apr-1997′, ‘dd-mon-yyyy’)),
            \n<\/span><\/p>\n

            PARTITION q2_1997
            \n<\/span><\/p>\n

            VALUES LESS THAN (TO_DATE(’01-jul-1997′, ‘dd-mon-yyyy’)),
            \n<\/span><\/p>\n

            PARTITION q3_1997
            \n<\/span><\/p>\n

            VALUES LESS THAN (TO_DATE(’01-oct-1997′, ‘dd-mon-yyyy’))
            \n<\/span><\/p>\n

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

            SUBPARTITION q3_1997_s1 TABLESPACE ts1,
            \n<\/span><\/p>\n

            SUBPARTITION q3_1997_s2 TABLESPACE ts3,
            \n<\/span><\/p>\n

            SUBPARTITION q3_1997_s3 TABLESPACE ts5,
            \n<\/span><\/p>\n

            SUBPARTITION q3_1997_s4 TABLESPACE ts7
            \n<\/span><\/p>\n

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

            PARTITION q4_1997
            \n<\/span><\/p>\n

            VALUES LESS THAN (TO_DATE(’01-jan-1998′, ‘dd-mon-yyyy’))
            \n<\/span><\/p>\n

            SUBPARTITIONS 16
            \n<\/span><\/p>\n

            STORE IN (tbs1, tbs3, tbs5, tbs7, tbs8, tbs9, tbs10, tbs11),
            \n<\/span><\/p>\n

            PARTITION q1_1998
            \n<\/span><\/p>\n

            VALUES LESS THAN (TO_DATE(’01-apr-1998′, ‘dd-mon-yyyy’))
            \n<\/span><\/p>\n

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

            Range type\uc758 \uccab\ubc88\uc9f8 level\uc758 partition\uc740 emp_composite table\uc740 NUMBER type column (EMPNO)\uc774\uace0 sales_composite table\uc740 DATE type column (SALE_DATE)\uc774\ub2e4. Hash type\uc758 \ub450\ubc88\uc9f8 level\uc740 emp_composite table\uc740 NUMBER type column (SAL)\uc774\uace0 sales_composite table\uc740 NUMBER type column (ITEM)\uc774\ub2e4. Partition \uac01\uac01\uc740 4\uac1c, 5\uac1c\uc758 sub-partition\uc740 16\uac1c, 44\uac1c\ub85c \ub098\ub25c\ub2e4. Range level partition\uc740 \ub17c\ub9ac\uc801\uc778 \uc815\ub82c\uc774\uace0 Data\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c Hash sub-partition\uc5d0 \uc800\uc7a5\ub41c\ub2e4.
            \n<\/span><\/p>\n

            \n

            Composite-type partition\uc758 \uc7a5\uc810
            \n<\/span><\/h4>\n<\/p>\n
              \n
            1. \n
              Range type\uc774 \uac00\uc9c0\ub294 \uad00\ub9ac\uc0c1\uc758 \uc774\uc810
              \n<\/span><\/div>\n<\/li>\n
            2. \n
              Data \uc800\uc7a5\uc758 \ud6a8\uacfc\uc801\uc778 \ubd84\uc0b0
              \n<\/span><\/div>\n<\/li>\n
            3. \n
              Range level\uc758 Global index\uc640 Sub-partition (Hash)level\uc758 Local index\uc758 \uc870\ud569\uc774 \uac00\ub2a5
              \n<\/span><\/div>\n<\/li>\n
            4. \n
              Hash \ubc29\ubc95\uc740 parallel mode\uc0c1\uc5d0\uc11c PDML\uc744 \uac00\ub2a5\ud558\uac8c \ud55c\ub2e4.
              \n<\/span><\/div>\n<\/li>\n<\/ol>\n

              \n

              Partition\uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub294 View
              \n<\/span><\/h4>\n<\/p>\n
              \n\n\n\n<\/colgroup>\n\n\n
              \n

              DBA_TAB_SUBPARTITIONS
              \n<\/span><\/p>\n

              DBA_SUBPART_KEY_COLUMNS
              \n<\/span><\/p>\n

              DBA_SUBPART_COL_STATISTICS
              \n<\/span><\/p>\n

              DBA_SUBPART_HISTOGRAMS
              \n<\/span><\/p>\n

              DBA_IND_SUBPARTITIONS
              \n<\/span><\/p>\n

              DBA_LOB_SUBPARTITIONS<\/span><\/p>\n<\/td>\n

              		\n

              Subpartition\uc758 \uc815\ubcf4\uc640 storage \uc18d\uc131 \uc815\ubcf4
              \n<\/span><\/p>\n

              Subpartition\uc758 key column\uc815\ubcf4
              \n<\/span><\/p>\n

              Subpartition\uc758 \ud1b5\uacc4, \ubd84\ud3ec \uc815\ubcf4
              \n<\/span><\/p>\n

              Subpartition\uc758 \uc2e4\uc81c \ubd84\ud3ec \uc815\ubcf4
              \n<\/span><\/p>\n

              Subpartition index\uc758 partition, storage, \ud1b5\uacc4 \uc815\ubcf4
              \n<\/span><\/p>\n

              LOB Subpartition \uc758 partition, storage \uc815\ubcf4<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n


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

              select partition_name,
              \n<\/span><\/p>\n

              subpartition_name,
              \n<\/span><\/p>\n

              subpartition_position,
              \n<\/span><\/p>\n

              tablespace_name
              \n<\/span><\/p>\n

              from user_tab_subpartitions
              \n<\/span><\/p>\n

              where table_name = ‘EMP_COMPOSITE’;
              \n<\/span><\/p>\n


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

              PARTITION_NAME SUBPARTITION_NAME SUBPARTITION_POSITION TABLESPACE_NAME
              \n<\/span><\/p>\n

              ————– —————– ——————— —————
              \n<\/span><\/p>\n

              P1 SYS_SUBP27 1 DATA01
              \n<\/span><\/p>\n

              P1 SYS_SUBP28 2 DATA02
              \n<\/span><\/p>\n

              P1 SYS_SUBP29 3 DATA03
              \n<\/span><\/p>\n

              P1 SYS_SUBP30 4 DATA04
              \n<\/span><\/p>\n

              P2 SYS_SUBP31 1 DATA01
              \n<\/span><\/p>\n

              P2 SYS_SUBP32 2 DATA02
              \n<\/span><\/p>\n

              P2 SYS_SUBP33 3 DATA03
              \n<\/span><\/p>\n

              P2 SYS_SUBP34 4 DATA04
              \n<\/span><\/p>\n

              P3 SYS_SUBP35 1 DATA01
              \n<\/span><\/p>\n

              P3 SYS_SUBP36 2 DATA02
              \n<\/span><\/p>\n

              P3 SYS_SUBP37 3 DATA03
              \n<\/span><\/p>\n

              P3 SYS_SUBP38 4 DATA04
              \n<\/span><\/p>\n

              P4 SYS_SUBP39 1 DATA01
              \n<\/span><\/p>\n

              P4 SYS_SUBP40 2 DATA02
              \n<\/span><\/p>\n

              P4 SYS_SUBP41 3 DATA03
              \n<\/span><\/p>\n

              P4 SYS_SUBP42 4 DATA04<\/span>
              \n\t<\/span><\/p>\n


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


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

              \n

              Partition\uc758 \uad6c\ud604
              \n<\/span><\/h2>\n<\/p>\n


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


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

              \n

              \uad6c\ud604 \ubc29\ubc95
              \n<\/span><\/h3>\n<\/p>\n

              \uc774\ub860\uc801\uc73c\ub85c \ubaa8\ub4e0 \uc870\ud569\uc774 \uac00\ub2a5\ud558\ub2e4.
              \n<\/span><\/p>\n

              – Partitioned table and non-partitioned index.
              \n<\/span><\/p>\n

              – Partitioned table and partitioned index.
              \n<\/span><\/p>\n

              – Non-partitioned table and non-partitioned index.
              \n<\/span><\/p>\n

              – Non-partitioned table and partitioned index.
              \n<\/span><\/p>\n


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

              \n

              \uc81c\uc57d \uc0ac\ud56d
              \n<\/span><\/h3>\n<\/p>\n

              \n

              Table
              \n<\/span><\/h4>\n<\/p>\n
                \n
              1. \n
                Clustered table\uc740 partition\ud560 \uc218 \uc5c6\ub2e4.
                \n<\/span><\/div>\n<\/li>\n
              2. \n
                LONG \ub610\ub294 LONG RAW column\uc774 \uc788\ub294 table\uc740 partition\ud560 \uc218 \uc5c6\ub2e4. BLOB-type columns\uc740 \uac00\ub2a5\ud558\ub2e4.
                \n<\/span><\/div>\n<\/li>\n
              3. \n
                Index Only Table (IOT)\ub294 Range partition\ub9cc \uac00\ub2a5\ud558\ub2e4.
                \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                \n

                Index
                \n<\/span><\/h4>\n<\/p>\n
                  \n
                1. \n
                  Cluster\ub97c \uc704\ud55c index\ub294 partition\uc774 \ubd88\uac00\ub2a5 \ud558\ub2e4.
                  \n<\/span><\/div>\n<\/li>\n
                2. \n
                  Clustered table\ub97c \uc704\ud55c index\ub294 partition\uc774 \ubd88\uac00\ub2a5 \ud558\ub2e4.
                  \n<\/span><\/div>\n<\/li>\n
                3. \n
                  Bitmap index\ub294 local partitioned index\ub9cc \uac00\ub2a5\ud558\ub2e4.
                  \n<\/span><\/div>\n<\/li>\n
                4. \n
                  Non-partitioned table\ub85c \ub41c Bitmap index\ub294 partition\uc774 \ubd88\uac00\ub2a5 \ud558\ub2e4.
                  \n<\/span><\/div>\n<\/li>\n
                5. \n
                  Non-prefixed global index\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4.
                  \n<\/span><\/div>\n<\/li>\n
                6. \n
                  Local non-prefixed unique index\ub294 index key\uac00 \ud3ec\ud568\ub41c partition key\ub97c \uac00\uc838\uc57c \ud55c\ub2e4.
                  \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                  \n

                  \uacf5\ud1b5 \uc0ac\ud56d
                  \n<\/span><\/h4>\n<\/p>\n
                    \n
                  • \n
                    Multi-column partition key\ub294 16\uac1c \uae4c\uc9c0 \uc81c\ud55c\uc774 \uc788\ub2e4.
                    \n<\/span><\/div>\n<\/li>\n
                  • \n
                    \ub2e4\uc74c\uc758 column type\uc740 partition key\uc758 \ubd80\ubd84\uc774 \ub420 \uc218 \uc5c6\ub2e4 .
                    \n<\/span><\/div>\n<\/li>\n<\/ul>\n

                    – LEVEL \ub610\ub294 ROWID pseudo-types.
                    \n<\/span><\/p>\n

                    – \ub2e4\uc74c\uc758 type\uc758 column : Nested table, Varray, Object type, Ref, Rowid
                    \n<\/span><\/p>\n

                    – \uc11c\ub85c\ub2e4\ub978 type\uc758 LOB (BLOB,CLOB,NCLOB,BFILE)
                    \n<\/span><\/p>\n


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

                    \n

                    Index Partition
                    \n<\/span><\/h2>\n<\/p>\n

                    Oracle Version 8\uc774\uc0c1\uc5d0\uc11c Local \uacfc Global \ub450 \uac00\uc9c0 index\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc774 \ub450 \uac00\uc9c0\ub294 \ub2e4\uc2dc Local prefixed, Local non-prefixed, Global prefixed\ub85c \uc138\ubd84\ud560 \uc218 \uc788\ub2e4.
                    \n<\/span><\/p>\n

                    Index partition\uc740 \uc5f0\uad00\ub41c table\uc758 partition\/sub-partition\uc5d0 \ub300\ud55c \ucd94\uac00, \uc0ad\uc81c, \ubd84\ud560, \uc555\ucd95\uc5d0 \ub530\ub77c \uc790\ub3d9\uc801\uc73c\ub85c \uad00\ub9ac\ub41c\ub2e4. Index partition\uc5d0 \uc0ac\uc6a9\ub418\ub294 \ubc29\ubc95\uc740 \uadf8\uc5d0 \ub300\uc751\ud558\ub294 table\uc5d0 \uc0ac\uc6a9\ub418\ub294 \ubc29\ubc95\uacfc \ub3d9\uc77c\ud558\ub2e4.
                    \n<\/span><\/p>\n

                    Global index\ub294 base table\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uac83\uacfc \ub2e4\ub97c \uc218 \uc788\ub294 column\uc73c\ub85c partition\ub41c\ub2e4. Oracle\uc740 base table partition\uc774 \ubcc0\uacbd\ub41c \uacbd\uc6b0 index partition\uc744 \ucd5c\uc2e0\uc73c\ub85c \uc720\uc9c0\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c index partition\uc740 “UNUSABLE” \uc0c1\ud0dc\uac00 \ub418\uace0 rebuild\ud574\uc57c \ud55c\ub2e4.
                    \n<\/span><\/p>\n

                    \n

                    Local Index\uc758 \ud2b9\uc9d5
                    \n<\/span><\/h4>\n<\/p>\n
                      \n
                    1. \n
                      Local index\ub294 \uae30\ubc18\uc744 \ub450\uace0 \uc788\ub294 table\uacfc \ub3d9\uc77c\ud55c partition\uc73c\ub85c \uad6c\uc131\ub41c\ub2e4.
                      \n<\/span><\/div>\n<\/li>\n
                    2. \n
                      Local index\uc758 \uc18d\uc131
                      \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                      – \ub3d9\uc77c\ud55c \uc218\uc758 partition\/sub-partition
                      \n<\/span><\/p>\n

                      – partition table \uacfc \ub3d9\uc77c\ud55c \ud55c\uacc4
                      \n<\/span><\/p>\n

                      – \ub3d9\uc77c\ud55c partition key
                      \n<\/span><\/p>\n

                      \n

                      Prefixed \uc640 Non-prefixed\uc758 \ucc28\uc774
                      \n<\/span><\/h4>\n<\/p>\n
                        \n
                      1. \n
                        \ub9cc\uc57d partition key\uc758 \uad6c\uc131\uc774 index key, column\uc758 \uc67c\ucabd\ubd80\ubd84\uc774 \ub3d9\uc77c\ud55c \uc21c\uc11c\ub85c \uad6c\uc131\ub41c\ub2e4\uba74 prefixed\uc774\ub2e4.
                        \n<\/span><\/div>\n<\/li>\n
                      2. \n
                        Non prefixed global index\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4.
                        \n<\/span><\/div>\n<\/li>\n
                      3. \n
                        Non-partitioned index\ub294 Global prefixed index\ub85c \ubcf8\ub2e4.
                        \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                        \n

                        \uc608\uc81c\ub85c \uc0ac\uc6a9\ub420 Table
                        \n<\/span><\/h4>\n<\/p>\n


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

                        CREATE TABLE emp (
                        \n<\/span><\/p>\n

                        empno NUMBER NOT NULL,
                        \n<\/span><\/p>\n

                        ename VARCHAR2(10) NOT NULL,
                        \n<\/span><\/p>\n

                        job VARCHAR2(14),
                        \n<\/span><\/p>\n

                        deptno NUMBER
                        \n<\/span><\/p>\n

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

                        PARTITION BY RANGE (empno)
                        \n<\/span><\/p>\n

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

                        PARTITION part1 VALUES LESS THAN (30),
                        \n<\/span><\/p>\n

                        PARTITION part2 VALUES LESS THAN (60),
                        \n<\/span><\/p>\n

                        PARTITION part3 VALUES LESS THAN (MAXVALUE)
                        \n<\/span><\/p>\n

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


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

                        <\/p>\n

                        Prefixed Local Index
                        \n<\/span><\/h3>\n<\/p>\n

                        CREATE INDEX emp_idx1 ON emp(empno) LOCAL;
                        \n<\/span><\/p>\n

                        \uc774 index\ub294 index key ’empno’\uac00 partition key\uc640 \ub3d9\uc77c\ud558\uae30 \ub54c\ubb38\uc5d0 prefixed local index\uc774\ub2e4. emp table\uacfc \ub3d9\uc77c\ud55c key\ub97c \uc0ac\uc6a9\ud558\ubbc0\ub85c Oracle\uc5d0 \uc758\ud574 \uc790\ub3d9\uc73c\ub85c partition\ub418\uba70 index\uc5d0 partition \ubc94\uc704\ub97c \ub2e4\uc2dc \uc120\uc5b8\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4. Oracle\uc740 emp table \uacfc \ub3d9\uc77c\ud55c \ud615\ud0dc\uc758 3\uac1c\uc758 index partition\uc744 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud55c\ub2e4. Index key \uac01\uac01\uc740 base table\uacfc \ub3d9\uc77c\ud55c \uc81c\ud55c\uc744 \uac00\uc9c4 partition\uc5d0 \uc800\uc7a5\ub41c\ub2e4.
                        \n<\/span><\/p>\n

                        <\/p>\n

                        Prefixed \ubc29\ubc95\uc758 \uc8fc\uc694\ud55c \uc810\uc740 optimizer\uac00 index key\uc758 \ubc94\uc704\uc640 \ub9de\uc9c0\uc54a\ub294 index partition\uc740 \ubb34\uc2dc \ud55c\ub2e4\ub294 \uac83\uc774\ub2e4.
                        \n<\/span><\/p>\n

                        Query\uc758 \uc608 : select * from emp where empno = 62;
                        \n<\/span><\/p>\n


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

                        \u00e8<\/span> Optimizer\ub294 part1, part2 \ub450\uac1c\uc758 partition\uc740 \ubb34\uc2dc\ud558\uace0 \uace7\ubc14\ub85c 3\ubc88\uc9f8 index partition part3\uc744 scan\ud55c\ub2e4.
                        \n<\/span><\/p>\n


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

                        emp_idx1 Part1 part2 part3
                        \n<\/span><\/p>\n


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

                        Partition key range -> 0-29 30-59 60-MAXVALUE
                        \n<\/span><\/p>\n

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

                        Index key range -> 0-29 30-59 60-MAXVALUE
                        \n<\/span><\/p>\n

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

                        table emp -> empno
                        \n<\/span><\/p>\n


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

                        \n

                        Non-prefixed Local Index
                        \n<\/span><\/h3>\n<\/p>\n

                        <\/p>\n

                        CREATE INDEX emp_idx1 ON emp(deptno) LOCAL;
                        \n<\/span><\/p>\n

                        \uc774 index\ub294 index key ‘deptno’\uac00 partition key\uc640 \ub2e4\ub974\ubbc0\ub85c Non-prefixed local index\uc774\ub2e4. Oracle\uc740 base table\uacfc \ub3d9\uc77c\ud55c 3\uac1c\uc758 index partition\uc744 \uc0dd\uc131\ud558\uc9c0\ub9cc Index key\uc758 \ubb3c\ub9ac\uc801\uc778 \uc800\uc7a5\uc740 partition rule\uc744 \ub530\ub974\uc9c0 \uc54a\ub294\ub2e4.
                        \n<\/span><\/p>\n

                        <\/p>\n

                        \ub2e4\ub978 partition\uc0c1\uc5d0 index key\uc758 \ubd84\uc0b0\uc744 \uc758\ubbf8\ud558\ubbc0\ub85c index key\ub97c \ud3ec\ud568\ud558\ub294 query\uac00 \uc8fc\uc5b4\uc9c0\uba74 \uc120\ud0dd\ub41c \uac12\uc744 \uc870\ud68c\ud558\uae30 \uc704\ud558\uc5ec \ubaa8\ub4e0 index partition\uc774 scan\ub41c\ub2e4.
                        \n<\/span><\/p>\n

                        Query\uc758 \uc608 : select * from emp where deptno = X;
                        \n<\/span><\/p>\n


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

                        \u00e8<\/span> Optimizer\ub294 \ud2b9\uc815 index key\ub97c \uc54c\uc544\ub0b4\uae30 \uc704\ud574 emp_idx2\uc758 3\uac1c partition\uc744 \ud0d0\uc0c9\ud55c\ub2e4. Query\uc5d0 \uae30\uc220\ub41c \uac12\uc740 3\uac1c\uc758 index partition\uc911\uc5d0 \uc788\uac8c \ub41c\ub2e4.
                        \n<\/span><\/p>\n


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

                        emp_idx2 Part1 part2 part3
                        \n<\/span><\/p>\n


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

                        Partition key range -> 0-29 30-59 60-MAXVALUE
                        \n<\/span><\/p>\n

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

                        Index key range -> 55-95 56-18 57-82
                        \n<\/span><\/p>\n

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

                        table emp -> empno
                        \n<\/span><\/p>\n

                        \n

                        Non-prefixed Unique key Local Index
                        \n<\/span><\/h4>\n<\/p>\n

                        Non-prefixed unique key local index\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 index key\ub294 \ud558\ub098\uc758 partition\uc5d0\ub9cc \uc18d\ud574\uc57c \ud558\ubbc0\ub85c partition key\uc758 \ubd80\ubd84 \uc9d1\ud569\uc774\uc5b4\uc57c \ud55c\ub2e4. \uc989, Non-Prefixed Unique Index\ub294 \uc0dd\uc131\ud560 \uc218 \uc5c6\ub2e4.
                        \n<\/span><\/p>\n


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

                        <\/p>\n

                        Global prefixed Index
                        \n<\/span><\/h3>\n<\/p>\n

                        CREATE INDEX emp_idx3 ON emp(ename)
                        \n<\/span><\/p>\n

                        GLOBAL PARTITION BY RANGE (ename)
                        \n<\/span><\/p>\n

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

                        PARTITION p1 VALUES LESS THAN (‘N’),
                        \n<\/span><\/p>\n

                        PARTITION p2 VALUES LESS THAN (MAXVALUE)
                        \n<\/span><\/p>\n

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

                        <\/p>\n

                        \uc774 \ubc29\ubc95\uc740 table\uacfc \ub2e4\ub978 partition key\ub85c \ub9cc\ub4e4\uc5b4\uc9c4 index partition\uc744 \uac00\ub2a5\ud558\uac8c \ud55c\ub2e4. \uc774 \ud615\ud0dc\ub294 prefixed\uac00 \ub418\uc5b4\uc57c \ud55c\ub2e4. Index key\ub294 optimizer\uac00 query\uc5d0 \uc758\ud574 \uad00\ub828\ub41c partition\uc744 \uc120\ud0dd\ud558\ub294 \uac83\uc744 \uac00\ub2a5\ud558\uac8c \ud558\ub294 partition key\uc5d0 \uae30\ubc18\uc744 \ub454\ub2e4.
                        \n<\/span><\/p>\n

                        Query\uc758 \uc608 : select * from emp where ename like ‘B%’;
                        \n<\/span><\/p>\n


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

                        \u00e8<\/span> Optimizer\ub294 \uc790\ub3d9\uc73c\ub85c \uccab\ubc88\uc9f8 index partition P1\uc744 \uc120\ud0dd\ud55c\ub2e4. \uc774 partition\uc5d0 \uc788\ub294 row\ub294 \ub2e4\ub978 table partition\uc758 row\ub97c \ucc38\uc870\ud558\ub294 ROWID\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4.
                        \n<\/span><\/p>\n

                        emp_idx3 Part1 part2
                        \n<\/span><\/p>\n


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

                        Partition key range -> A-M N-MAXVALUE
                        \n<\/span><\/p>\n

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

                        Index key range -> A-M N-MAXVALUE
                        \n<\/span><\/p>\n

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

                        table emp -> empno
                        \n<\/span><\/p>\n

                        \n

                        \uc8fc\uc758\uc0ac\ud56d
                        \n<\/span><\/h4>\n<\/p>\n

                        \ubcc4\uac1c\uc758 table partition\uc0c1\uc5d0 index access\ub97c \ubd84\uc0b0\ud55c\ub2e4\uba74 disk I\/O \uc99d\uac00\uc640 \uac19\uc740 \uc131\ub2a5\uc800\ud558\ub97c \uc720\ubc1c\ud55c\ub2e4. Global index\ub294 Oracle\uc774 table\uc758 \uc7ac\uc870\uc9c1\uacfc \uac19\uc740 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud560 \ub54c \uc790\ub3d9\uc801\uc73c\ub85c index\ub97c \uad00\ub9ac\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 local index\ubcf4\ub2e4 \uad00\ub9ac\uac00 \uc5b4\ub835\ub2e4. Table\uc758 storage\ubcc0\uacbd\uc740 \ubaa8\ub4e0index partition\uc774 ‘UNUSABLE’ \uc0c1\ud0dc\ub85c \ubcc0\uacbd\ub420 \uc218 \uc788\ub2e4. \uc774\ub54c Index rebuild\uac00 \ud544\uc694\ud558\uace0 \uc18c\uc694\uc2dc\uac04\uc740 partition\uc758 \ud06c\uae30\ubcf4\ub2e4\ub294 table\uc758 \ud06c\uae30\uc5d0 \ube44\ub840\ud55c\ub2e4.
                        \n<\/span><\/p>\n


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

                        \n

                        Index\uc758 \uc0ac\uc6a9 \uc815\ucc45
                        \n<\/span><\/h3>\n<\/p>\n

                        \ud2b9\uc815 index \ud615\ud0dc\uc758 \uc120\ud0dd\uc740 application\uc758 \uc81c\uc57d\uc870\uac74\uc5d0 \ub2ec\ub824\uc788\uace0 \uae30\ub2a5\uc758 \uc131\ub2a5, \uc720\uc6a9\uc131, \uad00\ub9ac\uc758 \uc6a9\uc774\uc131\ub4e4 \uc0ac\uc774\uc5d0 \ud0c0\ud611\uc774 \ud544\uc694\ud558\ub2e4.
                        \n<\/span><\/p>\n

                        \n

                        \uc8fc\uc694 \uaddc\uce59
                        \n<\/span><\/h4>\n<\/p>\n
                          \n
                        1. \n
                          Local index\ub294 Global index\ubcf4\ub2e4 \uad00\ub9ac\uac00 \uc27d\uace0 \ub192\uc740 \uc720\uc6a9\uc131\uc774 \uc788\ub2e4.
                          \n<\/span><\/div>\n<\/li>\n
                        2. \n
                          Prefixed index\ub294 optimizer\uac00 query\uc640 \uad00\ub828\ub41c partition\uc744 \uc9c1\uc811 \ud0d0\uc0c9\ud560 \uc218 \uc788\uac8c \ud55c\ub2e4.
                          \n<\/span><\/div>\n<\/li>\n
                        3. \n
                          Local prefixed index\uc640 Global index\ub294 OLTP \ud615\ud0dc\uc5d0 \uc801\ud569\ud558\uace0 Local non prefixed index \ub294 Data warehousing \uacfc decision making \ud658\uacbd\uc5d0 \uc801\ud569\ud558\ub2e4.
                          \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                          \n

                          Index \ud615\ud0dc \uc120\ud0dd \uc2dc \uace0\ub824\uc0ac\ud56d
                          \n<\/span><\/h4>\n<\/p>\n
                            \n
                          1. \n
                            Index\uac00 index column\uc758 \uc67c\ucabd\ubd80\ud130 \uc21c\uc11c\ub85c partition \ub418\uc5b4\uc9c4\ub2e4. <\/span>\u00e8<\/span> Local prefixed
                            \n<\/span><\/div>\n<\/li>\n
                          2. \n
                            \ubcc4\uac1c\uc758 partition\uc5d0 parallel access\uc758 \uc0ac\uc6a9\uc774 \ud544\uc694 \ud558\uace0 \uc8fc\uc694\uc5c5\ubb34\uac00 DSS \ud658\uacbd\uc774\ub2e4. <\/span>\u00e8<\/span> Local non prefixed
                            \n<\/span><\/div>\n<\/li>\n
                          3. \n
                            Partition Key\ub97c \ud3ec\ud568\ud558\uc9c0 \uc54a\ub294 column\uc744 unique index\ub85c \ub9cc\ub4e4\ub824\uace0 \ud55c\ub2e4. <\/span>\u00e8<\/span> Global prefixed
                            \n<\/span><\/div>\n<\/li>\n
                          4. \n
                            OLTP \ud658\uacbd\uc774\ub2e4. <\/span>\u00e8<\/span> Global prefixed.
                            \n<\/span><\/div>\n<\/li>\n
                          5. \n
                            Local non prefixed index\ub294 DATE type\uac19\uc740 \ubc94\uc8fc\ub85c \ubd84\ud560\ub41c historical \ud615\ud0dc\uc5d0 \ud2b9\ud788 \uc720\uc6a9\ud558\ub2e4. date\uc640 \ub2e4\ub978 \ud615\ud0dc\uc758 \ubc94\uc8fc\ub85c database\ub97c \ud0d0\uc0c9\ud560 \ub54c \uc720\uc6a9\ud558\ub2e4. Partition\uc758 \ucd94\uac00, \uc0ad\uc81c\uc640 \uac19\uc740 \uc720\uc9c0\ubcf4\uc218\ub3c4 \uc27d\ub2e4.
                            \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

                            \n

                            LOB & IOT(Index Organized Table) Partition
                            \n<\/span><\/h2>\n<\/p>\n


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

                            \n

                            LOB Partition
                            \n<\/span><\/h3>\n<\/p>\n

                            8i\uc774\uc0c1\uc5d0\uc11c partition table\uc740 LOB type\uc758 column\uc744 \uac00\uc9c8\uc218 \uc788\uc73c\ub098 \uc774type\uc774 partition key\ub85c \uc0ac\uc6a9\ub420 \uc218 \uc5c6\ub2e4.
                            \n<\/span><\/p>\n

                            \n

                            \ud2b9\uc9d5
                            \n<\/span><\/h4>\n<\/p>\n
                              \n
                            1. \n
                              Partition table\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 LOB type : BLOB, CLOB, NCLOB, BFILE
                              \n<\/span><\/div>\n<\/li>\n
                            2. \n
                              \ubaa8\ub4e0 LOB type column\uc740 LOB\uc744 access\ub97c \uac00\ub2a5\ud558\uac8c \ud558\ub294 \uc5f0\uad00\ub41c index\uc640 \ud568\uaed8 data segment\ub97c \uc0dd\uc131\ud55c\ub2e4. LOB, LOB index\uc640 \uad00\ub828\ub41c storage\uc808\uc740 \uc5f0\uad00\ub41c table\uacfc \ub2e4\ub97c \uc218 \uc788\ub2e4.
                              \n<\/span><\/div>\n<\/li>\n
                            3. \n
                              LOB type column\uc744 \uac00\uc9c4 partition table\uc744 \uc704\ud574 table\uc758 partition\uc774\ub098 sub-partition\ub9cc\ud07cdata\uc640 index segment\ub97c \uc0dd\uc131\ud55c\ub2e4. \uc774\ub7ec\ud55c \ubcc4\uac1c\uc758 segment\ub294 table partition\uacfc \ub3d9\uc77c\ud558\uac8c \ubd84\ud560\ub41c\ub2e4.
                              \n<\/span><\/div>\n<\/li>\n
                            4. \n
                              Storage\uc808\uc740 table\uc5d0 \uc815\uc758\ud558\uac70\ub098 \uac01 partition\uc5d0 \uc9c1\uc811 \uc815\uc758\ud55c\ub2e4. \uac01 LOB type partition\uc740 tablespace \ubfd0\ub9cc \uc544\ub2c8\ub77c \uc790\uc2e0\uc758 storage\uc808\uc744 \uac00\uc9c8 \uc218 \uc788\ub2e4.
                              \n<\/span><\/div>\n<\/li>\n
                            5. \n
                              LOB\uc758 Index partition\uc740 \ud56d\uc0c1 LOB data\uc758 partition\uacfc \ub3d9\uc77c\ud55c tablespace\uc5d0 \uc800\uc7a5\ub41c\ub2e4. LOB\uc758 Index partition\uc744 \uc704\ud55c storage\uc808\uc758 \uc0ac\uc6a9\uc740 \ubd88\uac00\ub2a5 \ud558\ub2e4.
                              \n<\/span><\/div>\n<\/li>\n
                            6. \n
                              BFILE type column\uc758 \uacbd\uc6b0 external file\uc758 LOCATOR\ub9cc\uc740 \uac00\uc9c0\ubbc0\ub85c VARCHAR2 type column\uacfc \ub3d9\uc77c\ud55c \ubc29\ubc95\uc73c\ub85c \ucde8\uae09\ud55c\ub2e4.
                              \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                              \n

                              \uc608\uc81c Table
                              \n<\/span><\/h4>\n<\/p>\n


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

                              CREATE TABLE emp_lob (
                              \n<\/span><\/p>\n

                              empno NUMBER(4) NOT NULL,
                              \n<\/span><\/p>\n

                              ename VARCHAR2(10),
                              \n<\/span><\/p>\n

                              sal NUMBER(7,2),
                              \n<\/span><\/p>\n

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

                              LOB (image) STORE AS IMAGE_LOB
                              \n<\/span><\/p>\n

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

                              CHUNK 1
                              \n<\/span><\/p>\n

                              PCTVERSION 20
                              \n<\/span><\/p>\n

                              NOCACHE
                              \n<\/span><\/p>\n

                              LOGGING
                              \n<\/span><\/p>\n

                              TABLESPACE T_LOB
                              \n<\/span><\/p>\n

                              STORAGE (INITIAL 12k NEXT 12K PCTINCREASE 0)
                              \n<\/span><\/p>\n

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

                              TABLESPACE USERS
                              \n<\/span><\/p>\n

                              PARTITION BY RANGE(empno)
                              \n<\/span><\/p>\n

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

                              PARTITION emp_p1 VALUES LESS THAN (50),
                              \n<\/span><\/p>\n

                              PARTITION emp_p2 VALUES LESS THAN (100),
                              \n<\/span><\/p>\n

                              PARTITION emp_p3 VALUES LESS THAN (150),
                              \n<\/span><\/p>\n

                              PARTITION emp_p4 VALUES LESS THAN (MAXVALUE)
                              \n<\/span><\/p>\n

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

                              Table\uc740 4\uac1c\uc758 partition\uc73c\ub85c \ubd84\ud560\ub418\uc5c8\ub2e4. \uac01 partition\uc740 LOB type partition\uacfc \uc5f0\uad00\ub418\uc5b4 \uc788\uace0 LOB partition\ub4e4\uc740 \uac01\uac01 data partition\uacfc index partition\uc73c\ub85c \ubd84\ub9ac\ub418\uc5b4 \uc788\ub2e4.
                              \n<\/span><\/p>\n

                              <\/p>\n

                              <\/p>\n

                              Partition\uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub294 View
                              \n<\/span><\/h4>\n<\/p>\n

                              select TABLE_NAME, POSITION, TABLESPACE, PARTITION_NAME
                              \n<\/span><\/p>\n

                              from DBA_TAB_PARTITIONS
                              \n<\/span><\/p>\n

                              where TABLE_NAME = ‘EMP_LOB’;<\/span>

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

                              TABLE_NAME POSITION TABLESPACE PARTITION_NAME
                              \n<\/span><\/p>\n

                              ————— ———- ———- —————
                              \n<\/span><\/p>\n

                              EMP_LOB 1 USERS EMP_P1
                              \n<\/span><\/p>\n

                              EMP_LOB 2 USERS EMP_P2
                              \n<\/span><\/p>\n

                              EMP_LOB 3 USERS EMP_P3
                              \n<\/span><\/p>\n

                              EMP_LOB 4 USERS EMP_P4
                              \n<\/span><\/p>\n

                              <\/p>\n

                              <\/p>\n

                              select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, INDEX_NAME
                              \n<\/span><\/p>\n

                              from DBA_LOBS
                              \n<\/span><\/p>\n

                              where TABLE_NAME = ‘EMP_LOB’;<\/span>

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

                              TABLE_NAME COLUMN_NAME SEGMENT_NAME INDEX_NAME
                              \n<\/span><\/p>\n

                              ————— ————— ————— ————————-
                              \n<\/span><\/p>\n

                              EMP_LOB IMAGE IMAGE_LOB SYS_IL0000012665C00004$$
                              \n<\/span><\/p>\n


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

                              Index segment \uc774\ub984\uc740 Oracle\uc5d0 \uc758\ud574 \uc0dd\uc131\ub41c\ub2e4. \ub450\uac1c\uc758 Object “IMAGE_LOB \uc640 SYS_IL0000012665C00004$$”\ub294 \uac00\uc0c1\uc73c\ub85c Oracle\uc758 dictionary\uc5d0 \uc874\uc7ac\ud558\uc9c0\ub9cc \ubb3c\ub9ac\uc801\uc73c\ub85c\ub294 partition\ud615\ud0dc\ub85c \uc874\uc7ac\ud55c\ub2e4.
                              \n<\/span><\/p>\n

                              <\/p>\n

                              <\/p>\n

                              select TABLE_NAME, COLUMN, LOB_NAME, PARTITION,
                              \n<\/span><\/p>\n

                              LOB_PARTITION, LOB_INDPART, TABLESPACE
                              \n<\/span><\/p>\n

                              from DBA_LOB_PARTITIONS
                              \n<\/span><\/p>\n

                              where TABLE_NAME = ‘EMP_LOB’;
                              \n<\/span><\/p>\n


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

                              TABLE_NAME COLUMN LOB_NAME PARTITION LOB_PARTITION LOB_INDPART TABLESPACE
                              \n<\/span><\/p>\n

                              ———- —— ——— ——— ————- ———– ———-
                              \n<\/span><\/p>\n

                              EMP_LOB IMAGE IMAGE_LOB EMP_P1 SYS_LOB_P63 SYS_IL_P67 T_LOB
                              \n<\/span><\/p>\n

                              EMP_LOB IMAGE IMAGE_LOB EMP_P2 SYS_LOB_P64 SYS_IL_P68 T_LOB
                              \n<\/span><\/p>\n

                              EMP_LOB IMAGE IMAGE_LOB EMP_P3 SYS_LOB_P65 SYS_IL_P69 T_LOB
                              \n<\/span><\/p>\n

                              EMP_LOB IMAGE IMAGE_LOB EMP_P4 SYS_LOB_P66 SYS_IL_P70 T_LOB
                              \n<\/span><\/p>\n

                              <\/p>\n

                              <\/p>\n

                              select TABLE_NAME, COLUMN, LOB_NAME,
                              \n<\/span><\/p>\n

                              LOB_INDEX_NAME, CHUNK, PCTVERSION
                              \n<\/span><\/p>\n

                              from DBA_PART_LOBS
                              \n<\/span><\/p>\n

                              where TABLE_NAME = ‘EMP_LOB’;
                              \n<\/span><\/p>\n


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

                              TABLE_NAME COLUMN LOB_NAME LOB_INDEX_NAME CHUNK PCTVERSION
                              \n<\/span><\/p>\n

                              ———- —— ———- ———————— —— ———–
                              \n<\/span><\/p>\n

                              EMP_LOB IMAGE IMAGE_LOB SYS_IL0000012665C00004$$ 1 20
                              \n<\/span><\/p>\n

                              <\/p>\n

                              <\/p>\n

                              select INDEX_NAME, TABLE_NAME, TYPE,
                              \n<\/span><\/p>\n

                              COUNT, LOCALITY, ALIGNMENT
                              \n<\/span><\/p>\n

                              from DBA_PART_INDEXES
                              \n<\/span><\/p>\n

                              where TABLE_NAME = ‘EMP_LOB’;
                              \n<\/span><\/p>\n


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

                              INDEX_NAME TABLE_NAME TYPE COUNT LOCALITY ALIGNMENT
                              \n<\/span><\/p>\n

                              ———————— ———- ——- —— —— ————
                              \n<\/span><\/p>\n

                              SYS_IL0000012665C00004$$ EMP_LOB RANGE 4 LOCAL NON_PREFIXED
                              \n<\/span><\/p>\n

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


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

                              select INDEX_NAME, HIGH_VALUE, PARTITION,
                              \n<\/span><\/p>\n

                              POSITION, STATUS, TABLESPACE
                              \n<\/span><\/p>\n

                              from DBA_IND_PARTITIONS
                              \n<\/span><\/p>\n

                              where TABLE_NAME = ‘EMP_LOB’;
                              \n<\/span><\/p>\n


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

                              INDEX_NAME HIGH_VALUE PARTITION POSITION STATUS TABLESPACE
                              \n<\/span><\/p>\n

                              ———————— ———- ——— ——– —— ———-
                              \n<\/span><\/p>\n

                              SYS_IL0000012665C00004$$ 50 SYS_IL_P67 1 USABLE T_LOB
                              \n<\/span><\/p>\n

                              SYS_IL0000012665C00004$$ 100 SYS_IL_P68 2 USABLE T_LOB
                              \n<\/span><\/p>\n

                              SYS_IL0000012665C00004$$ 150 SYS_IL_P69 3 USABLE T_LOB
                              \n<\/span><\/p>\n

                              SYS_IL0000012665C00004$$ MAXVALUE SYS_IL_P70 4 USABLE T_LOB<\/span>
                              \n\t<\/span><\/p>\n


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

                              \n

                              IOT Partition
                              \n<\/span><\/h3>\n<\/p>\n

                              IOT\ub294 Version 8.1.5\uc774\uc0c1\uc5d0\uc11c partition\ub420 \uc218 \uc788\ub2e4.
                              \n<\/span><\/p>\n

                              \uc8fc\uc758: IOT\ub294 BTREE index \uad6c\uc870\ub97c \uac00\uc9c4\ub2e4. Index\uc758 leaf\ub4e4\uc5d0 table\uc758 row\ub4e4\uc744 \uc800\uc7a5\ud55c\ub2e4. Table\uc758 row\ub4e4\uc740 \uac01 IOT\uc758 \uc0dd\uc131\uc5d0 \ud544\uc218\uc801\uc778 primary key\uc0c1\uc5d0 \uc800\uc7a5\ub41c\ub2e4. IOT\ub97c \uc0dd\uc131\ud560 \ub54c overflow\uc601\uc5ed\uc774 \uc0dd\uc131\ub41c\ub2e4. \uc774\uac83\uc740 primary key\uc5d0 \ub9de\uc9c0\uc54a\ub294 row\uc758 \ubd80\ubd84\ub4e4\uc744 \uc800\uc7a5\ud55c\ub2e4. \uc774 \ubd80\uac00\uc801\uc778 segment\uc758 \ubaa9\uc801\uc740 \uac01 IOT block\uc5d0 \uc800\uc7a5\ub41c row\uc758 \ud06c\uae30\ub97c \uc81c\ud55c\ud558\ub294 \uac83\uc774\ub2e4.
                              \n<\/span><\/p>\n

                              \n

                              \uc81c\uc57d \uc0ac\ud56d
                              \n<\/span><\/h4>\n<\/p>\n
                                \n
                              1. \n
                                Partition\uc740 Range type\uc774\uc5b4\uc57c \ud55c\ub2e4.
                                \n<\/span><\/div>\n<\/li>\n
                              2. \n
                                Partition key\ub294 primary key\uc758 \ubd80\ubd84 \uc9d1\ud569\uc774\uc5b4\uc57c \ud55c\ub2e4.
                                \n<\/span><\/div>\n<\/li>\n
                              3. \n
                                Overflow zone\uc740 IOT partition\uacfc \ub3d9\uc77c\ud558\uac8c partition\ub418\uc5b4\uc57c \ud55c\ub2e4.
                                \n<\/span><\/div>\n<\/li>\n
                              4. \n
                                Partition key\ub294 primary key\uc758 \ubd80\ubd84 \uc9d1\ud569\uc774\uac70\ub098 unique constraint \ud655\uc778\uc774 \uac00\ub2a5\ud55c Column\uc774 \ud3ec\ud568\ub418\ub3c4\ub85d \ud55c\ub2e4. Partition key\uac00 prefixed\ub77c\uba74 partition\uc5d0 \uae30\ubc18\uc744 \ub454 query\ub294 primary key\uc0c1\uc5d0 \uc800\uc7a5\ub41c row\ub97c \uc9c1\uc811 \uc870\ud68c\ud55c\ub2e4.
                                \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                \n

                                \uc608\uc81c Table
                                \n<\/span><\/h4>\n<\/p>\n


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

                                CREATE TABLE emp_iot(
                                \n<\/span><\/p>\n

                                empno NUMBER(4) PRIMARY KEY,
                                \n<\/span><\/p>\n

                                ename VARCHAR2(10),
                                \n<\/span><\/p>\n

                                sal NUMBER(7,2)
                                \n<\/span><\/p>\n

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

                                ORGANIZATION INDEX INCLUDING ename OVERFLOW
                                \n<\/span><\/p>\n

                                PARTITION BY RANGE(empno)
                                \n<\/span><\/p>\n

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

                                PARTITION emp_p1 VALUES LESS THAN (50) TABLESPACE data01,
                                \n<\/span><\/p>\n

                                PARTITION emp_p2 VALUES LESS THAN (100) TABLESPACE data02,
                                \n<\/span><\/p>\n

                                PARTITION emp_p3 VALUES LESS THAN (150) TABLESPACE data03,
                                \n<\/span><\/p>\n

                                PARTITION emp_p4 VALUES LESS THAN (MAXVALUE) TABLESPACE data04
                                \n<\/span><\/p>\n

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

                                \uac01 IOT partition\uc740 \ub450\uac1c\uc758 partition\uc744 \uc0dd\uc131\ud55c\ub2e4: data partition\uacfc overflow partition\uc774\uba70 Overflow partition\uc740 ename column\uc744 \ucd08\uacfc\ud558\ub294 row\ub97c \uc800\uc7a5\ud55c\ub2e4.
                                \n<\/span><\/p>\n


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

                                <\/p>\n

                                Partition\uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub294 View
                                \n<\/span><\/h4>\n<\/p>\n

                                select TABLE_NAME, IOT_NAME, IOT_TYPE, PARTITIONED
                                \n<\/span><\/p>\n

                                from DBA_TABLES;
                                \n<\/span><\/p>\n


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

                                TABLE_NAME IOT_NAME IOT_TYPE PARTITIONED
                                \n<\/span><\/p>\n

                                ——————– ———- ———— ———–
                                \n<\/span><\/p>\n

                                EMP_IOT IOT YES
                                \n<\/span><\/p>\n

                                SYS_IOT_OVER_12770 EMP_IOT IOT_OVERFLOW YES
                                \n<\/span><\/p>\n

                                <\/p>\n

                                select TABLE_NAME, PARTITIONING_TYPE, PARTITION_COUNT, DEF_TABLESPACE_NAME
                                \n<\/span><\/p>\n

                                from DBA_PART_TABLES;
                                \n<\/span><\/p>\n


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

                                TABLE_NAME PARTITIONING_TYPE PARTITION_COUNT DEF_TABLESPACE_NAME
                                \n<\/span><\/p>\n

                                —————— —————– ————— ——————-
                                \n<\/span><\/p>\n

                                SYS_IOT_OVER_12770 RANGE 4 USERS
                                \n<\/span><\/p>\n

                                <\/p>\n

                                <\/p>\n

                                select INDEX_NAME, INDEX_TYPE, TABLE_NAME, UNIQUENESS, PARTITIONED
                                \n<\/span><\/p>\n

                                from DBA_INDEXES;
                                \n<\/span><\/p>\n


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

                                INDEX_NAME INDEX_TYPE TABLE_NAME UNIQUENESS PARTITIONED
                                \n<\/span><\/p>\n

                                —————— ———– ———– ———- ———–
                                \n<\/span><\/p>\n

                                SYS_IOT_TOP_12770 IOT – TOP EMP_IOT UNIQUE YES
                                \n<\/span><\/p>\n

                                <\/p>\n

                                <\/p>\n

                                select INDEX_NAME, PARTITION_NAME, HIGH_VALUE, TABLESPACE_NAME
                                \n<\/span><\/p>\n

                                from DBA_IND_PARTITIONS;
                                \n<\/span><\/p>\n


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

                                INDEX_NAME PARTITION_NAME HIGH_VALUE TABLESPACE_NAME
                                \n<\/span><\/p>\n

                                —————– ————– ———- —————
                                \n<\/span><\/p>\n

                                SYS_IOT_TOP_12770 EMP_P1 50 DATA01
                                \n<\/span><\/p>\n

                                SYS_IOT_TOP_12770 EMP_P2 100 DATA02
                                \n<\/span><\/p>\n

                                SYS_IOT_TOP_12770 EMP_P3 150 DATA03
                                \n<\/span><\/p>\n

                                SYS_IOT_TOP_12770 EMP_P4 MAXVALUE DATA04
                                \n<\/span><\/p>\n

                                <\/p>\n

                                <\/p>\n

                                select TABLE_NAME, PARTITION_POSITION, PARTITION_NAME, TABLESPACE_NAME
                                \n<\/span><\/p>\n

                                from DBA_TAB_PARTITIONS;
                                \n<\/span><\/p>\n


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

                                TABLE_NAME PARTITION_POSITION PARTITION_NAME TABLESPACE_NAME
                                \n<\/span><\/p>\n

                                ——————– —————— ————— —————
                                \n<\/span><\/p>\n

                                SYS_IOT_OVER_12770 1 EMP_P1 USERS
                                \n<\/span><\/p>\n

                                SYS_IOT_OVER_12770 2 EMP_P2 USERS
                                \n<\/span><\/p>\n

                                SYS_IOT_OVER_12770 3 EMP_P3 USERS
                                \n<\/span><\/p>\n

                                SYS_IOT_OVER_12770 4 EMP_P4 USERS
                                \n<\/span><\/p>\n


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

                                DBA_TAB_PARTITIONS view\uc5d0\uc11c, overflow\uc640 \uc5f0\uad00\ub41c data segment\ub294 EMP_IOT table\uc744 \uc0dd\uc131\ud55c user\uc758 default tablespace\uc5d0 \uc800\uc7a5\ub41c\ub2e4. \uc774\ub294 overflow segment\uc640 \uc5f0\uad00\ub41c tablespace\uac00 \uc5c6\uace0 table\uc5d0 tablespace\uac00 \uc815\uc758\ub418\uc9c0 \uc54a\uc558\uae30 \ub54c\ubb38\uc774\ub2e4. table\uc744 \uc704\ud55c default tablespace\uac00 \uc788\ub2e4\uba74 overflow segment\ub294 \uadf8 tablespace\uc5d0 \uc0dd\uc131\ub41c\ub2e4.
                                \n<\/span><\/p>\n

                                \n

                                IOT\uc758 \ub2e4\ub978 column\uc5d0 \uc815\uc758\ud560 \uc218 \uc788\ub294 index
                                \n<\/span><\/h4>\n<\/p>\n

                                Local prefixed, Local non prefixed, \ub610\ub294 global prefixed index\uac00 \uac00\ub2a5\ud558\ub2e4.
                                \n<\/span><\/p>\n


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

                                \n

                                Partition\uc5d0 \ub300\ud55c \uc791\uc5c5
                                \n<\/span><\/h2>\n<\/p>\n

                                \n

                                Test\ub97c \uc704\ud55c \uc608\uc81c Table
                                \n<\/span><\/h4>\n<\/p>\n

                                CREATE TABLE test (
                                \n<\/span><\/p>\n

                                empno NUMBER(4) NOT NULL,
                                \n<\/span><\/p>\n

                                ename VARCHAR2(10),
                                \n<\/span><\/p>\n

                                sal NUMBER(7,2)
                                \n<\/span><\/p>\n

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

                                PARTITION BY RANGE(empno)
                                \n<\/span><\/p>\n

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

                                PARTITION emp_p1 VALUES LESS THAN (50),
                                \n<\/span><\/p>\n

                                PARTITION emp_p2 VALUES LESS THAN (100),
                                \n<\/span><\/p>\n

                                PARTITION emp_p3 VALUES LESS THAN (150),
                                \n<\/span><\/p>\n

                                PARTITION emp_p4 VALUES LESS THAN (200)
                                \n<\/span><\/p>\n

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


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


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

                                \n

                                Partition\uc758 \uc774\ub3d9
                                \n<\/span><\/h3>\n<\/p>\n

                                <\/p>\n

                                Table partition\uc744 \ub2e4\ub978 tablespace\ub85c \uc774\ub3d9 \ud558\ub294 \uac83\uc774 \uac00\ub2a5\ud558\ub2e4. \uc774 partition\uacfc \uad00\ub828\ub41c Local index partition\uc758 \uc0c1\ud0dc\ub294 ‘UNUSABLE’\uc774 \ub41c\ub2e4. Global Index\uc778 \uacbd\uc6b0 \ubaa8\ub4e0 partition\uc774 ‘UNUSABLE’\uc774 \ub418\ubbc0\ub85c \uc804\uccb4 index\ub97c rebuild\ud574\uc57c \ud55c\ub2e4.
                                \n<\/span><\/p>\n

                                ALTER TABLE test MOVE PARTITION emp_p1 tablespace tbs1;
                                \n<\/span><\/p>\n

                                \u00e8<\/span> Table test\uc758 \uccab\ubc88\uc9f8 partition emp_p1\uc744 tbs1 tablespace\ub85c \uc774\ub3d9\ud55c\ub2e4.<\/span>
                                \n\t<\/span><\/p>\n

                                \n

                                Index\uc758 \uc0c1\ud0dc
                                \n<\/span><\/h4>\n<\/p>\n
                                  \n
                                1. \n
                                  Local Index\ub294 \ud574\ub2f9 partition\uc758 index\ub97c rebuild\ud574\uc57c \ud55c\ub2e4.
                                  \n<\/span><\/div>\n<\/li>\n
                                2. Global index\uc778 \uacbd\uc6b0 \uc804\uccb4 partition\uc5d0 \ub300\ud55c rebuild\uac00 \ud544\uc694\ud558\ub2e4.<\/span>
                                  \u00e8<\/span>ALTER INDEX test_idx1 REBUILD PARTITION partition_name;
                                  \n<\/span><\/li>\n<\/ol>\n


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

                                  \n

                                  Partition\uc758 \ucd94\uac00
                                  \n<\/span><\/h3>\n<\/p>\n

                                  <\/p>\n

                                  \uc0c1\ud55c\uac12\uc774 MAXVALUE\uac00 \uc544\ub2c8\ub77c\uba74 \ub9c8\uc9c0\ub9c9 partition \ub2e4\uc74c\uc5d0 \uc0c8\ub85c\uc6b4 partition\uc758 \ucd94\uac00\uac00 \uac00\ub2a5\ud558\ub2e4. \uc0c1\ud55c\uac12\uc774 MAXVALUE\ub77c\uba74 \ucd94\uac00\ub294 \ubd88\uac00\ub2a5 \ud558\ubbc0\ub85c SPLIT\uc744 \uc774\uc6a9\ud574\uc11c \uc911\uac04\uc5d0 partition \ucd94\uac00 \ud574\uc57c\ud55c\ub2e4. SPLIT\ub294 \uc874\uc7ac\ud558\ub294 partition\uc744 \ub450\uac1c\uc758 \ubcc4\uac1c\uc758 partition\uc744 \ub9cc\ub4e0\ub2e4. \uc0c1\uc704\uc758 partition\uc5d0 \uc801\uc6a9\ud55c\ub2e4\uba74 SPLIT\ub294 \uc0c1\ud55c\uc120 \ub2e4\uc74c\uc5d0 \ubcc4\ub3c4\uc758 partition\uc744 \ucd94\uac00\ud55c\ub2e4.
                                  \n<\/span><\/p>\n

                                  ALTER TABLE test ADD PARTITION emp_p5 values less than (250);
                                  \n<\/span><\/p>\n

                                  \u00e8<\/span> Table test\uc758 \ub9c8\uc9c0\ub9c9 partition emp_p4 \ub2e4\uc74c\uc5d0 emp_p5\ub97c \ucd94\uac00\ud55c\ub2e4.<\/span>
                                  \n\t<\/span><\/p>\n

                                  \n

                                  Index\uc758 \uc0c1\ud0dc
                                  \n<\/span><\/h4>\n<\/p>\n
                                    \n
                                  1. \n
                                    Global index\uc758 \uc0c1\ud55c\uac12\uc740 \ud56d\uc0c1 MAXVALUE\uac00 \ub418\ubbc0\ub85c SPLIT\ub97c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4.
                                    \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                    \n

                                    \uc81c\uc57d \uc0ac\ud56d
                                    \n<\/span><\/h4>\n<\/p>\n
                                      \n
                                    1. \n
                                      Partition index\uc758 \uacbd\uc6b0 Global index\uc5d0\uc11c\ub9cc \uc0ac\uc6a9 \uac00\ub2a5\ud558\ub2e4.
                                      \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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


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

                                      \n

                                      Partition\uc758 \uc0ad\uc81c
                                      \n<\/span><\/h3>\n<\/p>\n

                                      Table\uc774\ub098 Global index partition\uc758 \uc0ad\uc81c\uac00 \uac00\ub2a5\ud558\ub2e4. Partition table \uc758 DROP\uc740 Global index\uc758 \ubaa8\ub4e0 partition\uc758 \uc0c1\ud0dc\uac00 ‘UNUSABLE’\ub85c \ubc14\ub00c\ubbc0\ub85c \uc804\uccb4 index\uc758 rebuild\uac00 \ud544\uc694\ud558\ub2e4.
                                      \n<\/span><\/p>\n


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

                                      ALTER TABLE test DROP PARTITION emp_p1;
                                      \n<\/span><\/p>\n

                                      \u00e8<\/span> Table test\uc758 \uccab\ubc88\uc9f8 partition emp_p1\uc744 \uc0ad\uc81c\ud55c\ub2e4.<\/span>
                                      \n\t<\/span><\/p>\n

                                      \n

                                      Index\uc758 \uc0c1\ud0dc
                                      \n<\/span><\/h4>\n<\/p>\n
                                        \n
                                      1. \n
                                        Global index\uc778 \uacbd\uc6b0 \uc804\uccb4 partition\uc5d0 \ub300\ud55c rebuild\uac00 \ud544\uc694\ud558\ub2e4.
                                        \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                        \n

                                        \uc81c\uc57d \uc0ac\ud56d
                                        \n<\/span><\/h4>\n<\/p>\n
                                          \n
                                        1. \n
                                          Hash partitioned table\uc5d0\ub294 \ubd88\uac00\ub2a5 \ud558\uace0 COALESCE command\ub97c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4.
                                          \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

                                          \n

                                          Partition\uc758 truncate
                                          \n<\/span><\/h3>\n<\/p>\n

                                          \ud574\ub2f9 partition\uc758 \ubaa8\ub4e0 row\ub97c \uc0ad\uc81c\ud558\uace0 \ud560\ub2f9\ub41c storage\ub294 \ubcf4\uc874\ub41c\ub2e4. Local index\ub294 \uc790\ub3d9\uc73c\ub85c \ubcc0\uacbd\ub418\uc9c0\ub9cc Global index\uc758 \uacbd\uc6b0 ‘UNUSABLE’ \uc0c1\ud0dc\uac00 \ub41c\ub2e4.
                                          \n<\/span><\/p>\n


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

                                          ALTER TABLE test TRUNCATE PARTITION emp_p1;
                                          \n<\/span><\/p>\n

                                          \u00e8<\/span> Table test\uc758 \uccab\ubc88\uc9f8 partition emp_p1\uc744 truncate\ud55c\ub2e4.<\/span>
                                          \n\t<\/span><\/p>\n

                                          \n

                                          Index\uc758 \uc0c1\ud0dc
                                          \n<\/span><\/h4>\n<\/p>\n
                                            \n
                                          1. \n
                                            Global index\uc778 \uacbd\uc6b0 \uc804\uccb4 partition\uc5d0 \ub300\ud55c rebuild\uac00 \ud544\uc694\ud558\ub2e4.
                                            \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                            \n

                                            \uc81c\uc57d \uc0ac\ud56d
                                            \n<\/span><\/h4>\n<\/p>\n
                                              \n
                                            1. \n
                                              Index\uc5d0\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4.
                                              \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

                                              \n

                                              Partition\uc758 \ubd84\ud560
                                              \n<\/span><\/h3>\n<\/p>\n

                                              <\/p>\n

                                              \ud558\ub098\uc758 Partition\uc758 \ub0b4\uc6a9\uc744 \ub450\uac1c\uc758 \uac1c\ubcc4\uc801\uc778 partition\uc73c\ub85c \ubd84\ub9ac\ud55c\ub2e4. \uc5f0\uad00\ub41c Global\/Local index partition \ub294 ‘UNUSABLE’ \uc0c1\ud0dc\uac00 \ub41c\ub2e4.
                                              \n<\/span><\/p>\n

                                              ALTER TABLE test SPLIT PARTITION emp_p1 AT (25)
                                              \n<\/span><\/p>\n

                                              INTO (PARTITION emp_p11, PARTITION emp_p12);
                                              \n<\/span><\/p>\n

                                              \u00e8<\/span> emp_p1 partition\uc740 \ub450\uac1c\uc758 partition emp_p11 \uacfc emp_p12 \ub85c \ub098\ub25c\ub2e4. \ub450\uac1c\uc758 partition\uc740 1-24, 25-49\ub85c \uc7ac\uc815\uc758\ub41c\ub2e4.
                                              \n<\/span><\/p>\n

                                              ALTER TABLE test SPLIT PARTITION emp_p1 AT (25)
                                              \n<\/span><\/p>\n

                                              INTO (PARTITION emp_p1, PARTITION emp_p2);
                                              \n<\/span><\/p>\n

                                              \u00e8<\/span> emp_p1\uc774 emp_p1, emp_p2\ub85c \ub098\ub25c\ub2e4.
                                              \n<\/span><\/p>\n

                                              \n

                                              Index\uc758 \uc0c1\ud0dc
                                              \n<\/span><\/h4>\n<\/p>\n
                                                \n
                                              1. \n
                                                Local Index\ub294 \ud574\ub2f9 partition\uc758 index\ub97c rebuild\ud574\uc57c \ud55c\ub2e4.
                                                \n<\/span><\/div>\n<\/li>\n
                                              2. \n
                                                Global index\uc778 \uacbd\uc6b0 \uc804\uccb4 partition\uc5d0 \ub300\ud55c rebuild\uac00 \ud544\uc694\ud558\ub2e4.
                                                \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                \n

                                                \uc81c\uc57d \uc0ac\ud56d
                                                \n<\/span><\/h4>\n<\/p>\n
                                                  \n
                                                1. \n
                                                  Global index\uc5d0\uc11c\ub3c4 \uc801\uc6a9\ub41c\ub2e4.
                                                  \n<\/span><\/div>\n<\/li>\n
                                                2. \n
                                                  Hash partition\uc5d0\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uace0 ADD\uac00 \ub300\uc2e0 \uc0ac\uc6a9\ub41c\ub2e4.
                                                  \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                  \n

                                                  Hash-type Partition \ubd84\ud560\uc758 \uc608
                                                  \n<\/span><\/h4>\n<\/p>\n

                                                  Hash-type partition\uc758 \uc608\ub85c \uc0ac\uc6a9\ub418\uc5c8\ub358 emp_hpart\ub294 4\uac1c\uc758 partition P1, P2, P3, P4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4.
                                                  \n<\/span><\/p>\n


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

                                                  PARTITION_NAME PARTITION_POSITION TABLESPACE_NAME
                                                  \n<\/span><\/p>\n

                                                  ————— —————— —————
                                                  \n<\/span><\/p>\n

                                                  P1 1 DATA01
                                                  \n<\/span><\/p>\n

                                                  P2 2 DATA02
                                                  \n<\/span><\/p>\n

                                                  P3 3 DATA03
                                                  \n<\/span><\/p>\n

                                                  P4 4 DATA04
                                                  \n<\/span><\/p>\n


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

                                                  SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME HEADER_FILE HEADER_BLOCK
                                                  \n<\/span><\/p>\n

                                                  ————— ————— ————— ———– ————
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P1 DATA01 8 21
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P2 DATA02 9 21
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P3 DATA03 10 2
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P4 DATA04 11 2
                                                  \n<\/span><\/p>\n


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

                                                  – \uccab\ubc88\uc9f8 partition P1\uc758 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4
                                                  \n<\/span><\/p>\n


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

                                                  EMPNO ENAME SAL
                                                  \n<\/span><\/p>\n

                                                  ———- ———- ———-
                                                  \n<\/span><\/p>\n

                                                  303 TEST 10302
                                                  \n<\/span><\/p>\n

                                                  306 TEST 10305
                                                  \n<\/span><\/p>\n

                                                  310 TEST 10309
                                                  \n<\/span><\/p>\n

                                                  325 TEST 10324
                                                  \n<\/span><\/p>\n

                                                  326 TEST 10325
                                                  \n<\/span><\/p>\n

                                                  332 TEST 10331
                                                  \n<\/span><\/p>\n

                                                  338 TEST 10337
                                                  \n<\/span><\/p>\n

                                                  341 TEST 10340
                                                  \n<\/span><\/p>\n

                                                  343 TEST 10342
                                                  \n<\/span><\/p>\n

                                                  347 TEST 10346
                                                  \n<\/span><\/p>\n

                                                  348 TEST 10347
                                                  \n<\/span><\/p>\n

                                                  349 TEST 10348
                                                  \n<\/span><\/p>\n

                                                  350 TEST 10349
                                                  \n<\/span><\/p>\n

                                                  360 TEST 10359
                                                  \n<\/span><\/p>\n

                                                  361 TEST 10360
                                                  \n<\/span><\/p>\n

                                                  365 TEST 10364
                                                  \n<\/span><\/p>\n

                                                  368 TEST 10367
                                                  \n<\/span><\/p>\n

                                                  370 TEST 10369
                                                  \n<\/span><\/p>\n

                                                  373 TEST 10372
                                                  \n<\/span><\/p>\n

                                                  380 TEST 10379
                                                  \n<\/span><\/p>\n

                                                  385 TEST 10384
                                                  \n<\/span><\/p>\n

                                                  386 TEST 10385
                                                  \n<\/span><\/p>\n

                                                  396 TEST 10395
                                                  \n<\/span><\/p>\n

                                                  400 TEST 10399
                                                  \n<\/span><\/p>\n

                                                  401 TEST 10400
                                                  \n<\/span><\/p>\n


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

                                                  25 rows selected.
                                                  \n<\/span><\/p>\n


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

                                                  – \ub2e4\uc74c command\ub294 \uc0c8\ub85c\uc6b4 partition P5\ub97c \ucd94\uac00\ud558\uace0 P1\uc758 row\ub4e4\uc744 P1\uc5d0\uc11c P5\uc5d0 \uc7ac\ubd84\uc0b0 \ud55c\ub2e4.
                                                  \n<\/span><\/p>\n

                                                  <\/p>\n

                                                  <\/p>\n

                                                  ALTER TABLE emp_hpart ADD PARTITION P5;
                                                  \n<\/span><\/p>\n


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

                                                  SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME HEADER_FILE HEADER_BLOCK
                                                  \n<\/span><\/p>\n

                                                  ————— ————— ————— ———– ————
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P1 DATA01 8 2
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P2 DATA02 9 21
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P3 DATA03 10 2
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P4 DATA04 11 2
                                                  \n<\/span><\/p>\n

                                                  EMP_HPART P5 USERS 5 1292
                                                  \n<\/span><\/p>\n


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

                                                  SQL> select * from emp_hpart partition(P1);
                                                  \n<\/span><\/p>\n


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

                                                  EMPNO ENAME SAL
                                                  \n<\/span><\/p>\n

                                                  ———- ———- ———-
                                                  \n<\/span><\/p>\n

                                                  306 TEST 10305
                                                  \n<\/span><\/p>\n

                                                  310 TEST 10309
                                                  \n<\/span><\/p>\n

                                                  325 TEST 10324
                                                  \n<\/span><\/p>\n

                                                  326 TEST 10325
                                                  \n<\/span><\/p>\n

                                                  338 TEST 10337
                                                  \n<\/span><\/p>\n

                                                  341 TEST 10340
                                                  \n<\/span><\/p>\n

                                                  343 TEST 10342
                                                  \n<\/span><\/p>\n

                                                  347 TEST 10346
                                                  \n<\/span><\/p>\n

                                                  350 TEST 10349
                                                  \n<\/span><\/p>\n

                                                  370 TEST 10369
                                                  \n<\/span><\/p>\n

                                                  373 TEST 10372
                                                  \n<\/span><\/p>\n

                                                  385 TEST 10384
                                                  \n<\/span><\/p>\n

                                                  400 TEST 10399
                                                  \n<\/span><\/p>\n

                                                  401 TEST 10400
                                                  \n<\/span><\/p>\n


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

                                                  14 rows selected.
                                                  \n<\/span><\/p>\n


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

                                                  SQL> select * from emp_hpart partition(P5);
                                                  \n<\/span><\/p>\n


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

                                                  EMPNO ENAME SAL
                                                  \n<\/span><\/p>\n

                                                  ———- ———- ———-
                                                  \n<\/span><\/p>\n

                                                  303 TEST 10302
                                                  \n<\/span><\/p>\n

                                                  332 TEST 10331
                                                  \n<\/span><\/p>\n

                                                  348 TEST 10347
                                                  \n<\/span><\/p>\n

                                                  349 TEST 10348
                                                  \n<\/span><\/p>\n

                                                  360 TEST 10359
                                                  \n<\/span><\/p>\n

                                                  361 TEST 10360
                                                  \n<\/span><\/p>\n

                                                  365 TEST 10364
                                                  \n<\/span><\/p>\n

                                                  368 TEST 1036
                                                  \n<\/span><\/p>\n

                                                  380 TEST 10379
                                                  \n<\/span><\/p>\n

                                                  386 TEST 10385
                                                  \n<\/span><\/p>\n

                                                  396 TEST 10395
                                                  \n<\/span><\/p>\n


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

                                                  11 rows selected.
                                                  \n<\/span><\/p>\n


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

                                                  – Partition P1\uc740 \uc9c0\uc6cc\uc9c0\uace0 \ub2e4\uc2dc \uc0dd\uc131\ub428\uc5d0 \uc720\uc758\ud558\uc790.
                                                  \n<\/span><\/p>\n


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

                                                  \n

                                                  Partition\uc758 \uad50\ud658
                                                  \n<\/span><\/h3>\n<\/p>\n

                                                  Non-partition table\uc744 partition\uc73c\ub85c \ub610\ub294 \uadf8 \ubc18\ub300\ub85c \uc62e\uaca8\uc900\ub2e4. \uc774 \uae30\ub2a5\uc740 \ud2b9\ud788 V7\uc758 partition view\ub97c partition table\ub85c migration\ud558\ub294\ub370 \uc720\uc6a9\ud558\ub2e4.
                                                  \n<\/span><\/p>\n

                                                  \ub2e4\uc74c\uacfc \uac19\uc774 4\uac1c\uc758 table less50, less100, less150, less200\ub97c \uc774\uc6a9\ud558\ub294 partition view\ub97c Partition Table\ub85c<\/span>\ubcc0\uacbd\ud574 \ubcf4\uc790.<\/span><\/p>\n


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

                                                  CREATE VIEW test_view AS
                                                  \n<\/span><\/p>\n

                                                  SELECT * FROM less50
                                                  \n<\/span><\/p>\n

                                                  UNION ALL
                                                  \n<\/span><\/p>\n

                                                  SELECT * FROM less100
                                                  \n<\/span><\/p>\n

                                                  UNION ALL
                                                  \n<\/span><\/p>\n

                                                  SELECT * FROM less150
                                                  \n<\/span><\/p>\n

                                                  UNION ALL
                                                  \n<\/span><\/p>\n

                                                  SELECT * FROM less200;
                                                  \n<\/span><\/p>\n

                                                    \n
                                                  1. \n
                                                    Partition view\uc758 Table\uacfc \ub3d9\uc77c\ud55c \uad6c\uc870\uc758 \ube48 partition Table\uc744 \uc0dd\uc131\ud55c\ub2e4.
                                                    \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                    CREATE TABLE new_test (
                                                    \n<\/span><\/p>\n

                                                    empno NUMBER(4) NOT NULL,
                                                    \n<\/span><\/p>\n

                                                    ename VARCHAR2(10),
                                                    \n<\/span><\/p>\n

                                                    sal NUMBER(7,2)
                                                    \n<\/span><\/p>\n

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

                                                    PARTITION BY RANGE(EMPNO)
                                                    \n<\/span><\/p>\n

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

                                                    PARTITION emp_p1 VALUES LESS THAN (50),
                                                    \n<\/span><\/p>\n

                                                    PARTITION emp_p2 VALUES LESS THAN (100),
                                                    \n<\/span><\/p>\n

                                                    PARTITION emp_p3 VALUES LESS THAN (150),
                                                    \n<\/span><\/p>\n

                                                    PARTITION emp_p4 VALUES LESS THAN (200)
                                                    \n<\/span><\/p>\n

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

                                                      \n
                                                    1. \n
                                                      View\ub97c \uad6c\uc131\ud558\ub294 \uac01 table\uc744 partition table\ub85c\uc758 \uc62e\uaca8\uc900\ub2e4.
                                                      \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                      ALTER TABLE new_test EXCHANGE PARTITION
                                                      \n<\/span><\/p>\n

                                                      emp_p1 WITH TABLE less50 WITH VALIDATION;<\/span>
                                                      \n\t<\/span><\/p>\n

                                                      \n

                                                      \uc7a5\uc810
                                                      \n<\/span><\/h4>\n<\/p>\n
                                                        \n
                                                      1. \n
                                                        \uc774 \uc791\uc5c5\uc740 Oracle\uc758 dictionary\ub97c \ubcc0\uacbd\ub9cc \ubc1c\uc0dd\ud558\uc5ec \uc544\uc8fc \uc9e7\uc740 \uc2dc\uac04\uc774 \uc18c\uc694\ub41c\ub2e4.
                                                        \n<\/span><\/div>\n<\/li>\n
                                                      2. \n
                                                        Segment\uc758 \ubb3c\ub9ac\uc801\uc778 \uc774\ub3d9\uc740 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4.
                                                        \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                        \n

                                                        \uc81c\uc57d \uc0ac\ud56d
                                                        \n<\/span><\/h4>\n<\/p>\n
                                                          \n
                                                        1. \n
                                                          Non-partition table\uc740 \ubb3c\ub860 partition table\ub85c\uc758 \ubc14\uafb8\uae30 \uc704\ud55c table\uc758 \uad6c\uc870\ub294 type, column, size, column\uc758 \uc218\uac00 \ub3d9\uc77c\ud574\uc57c \ud55c\ub2e4.
                                                          \n<\/span><\/div>\n<\/li>\n
                                                        2. \n
                                                          Hash partition\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uace0 \ub300\uc2e0 COALESCE\ub97c \uc0ac\uc6a9\ud55c\ub2e4.
                                                          \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

                                                          \n

                                                          Partition\uc758 coalesce
                                                          \n<\/span><\/h3>\n<\/p>\n

                                                          Hash \ud615\ud0dc\uc758 partition\uc744 \uc704\ud55c 8.1.5\uc758 \uc2e0\uae30\ub2a5\uc73c\ub85c \ub0a8\uaca8\uc9c4 partition\uc5d0 row\ub97c \uc7ac\ubd84\ubc30 \ud558\uace0 Oracle\uc740 \uc120\ud0dd\ub41c partition\uc744 \uc0ad\uc81c\ud55c\ub2e4.
                                                          \n<\/span><\/p>\n


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

                                                          ALTER TABLE test TRUNCATE PARTITION emp_p1;
                                                          \n<\/span><\/p>\n

                                                          \u00e8<\/span> Table test\uc758 \uccab\ubc88\uc9f8 partition emp_p1\uc744 truncate\ud55c\ub2e4.<\/span>
                                                          \n\t<\/span><\/p>\n


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

                                                          \n

                                                          Hash-type Partition Coalesce\uc758 \uc608
                                                          \n<\/span><\/h4>\n<\/p>\n

                                                          Hash-type partition\uc758 \uc608\ub85c \uc0ac\uc6a9\ub418\uc5c8\ub358 emp_hpart\ub294 4\uac1c\uc758 partition P1, P2, P3, P4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4.
                                                          \n<\/span><\/p>\n


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

                                                          PARTITION_NAME PARTITION_POSITION TABLESPACE_NAME
                                                          \n<\/span><\/p>\n

                                                          ————— —————— —————
                                                          \n<\/span><\/p>\n

                                                          P1 1 DATA01
                                                          \n<\/span><\/p>\n

                                                          P2 2 DATA02
                                                          \n<\/span><\/p>\n

                                                          P3 3 DATA03
                                                          \n<\/span><\/p>\n

                                                          P4 4 DATA04
                                                          \n<\/span><\/p>\n


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

                                                          SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME HEADER_FILE HEADER_BLOCK
                                                          \n<\/span><\/p>\n

                                                          ————— ————— ————— ———– ————
                                                          \n<\/span><\/p>\n

                                                          EMP_HPART P1 DATA01 8 21
                                                          \n<\/span><\/p>\n

                                                          EMP_HPART P2 DATA02 9 21
                                                          \n<\/span><\/p>\n

                                                          EMP_HPART P3 DATA03 10 2
                                                          \n<\/span><\/p>\n

                                                          EMP_HPART P4 DATA04 11 2
                                                          \n<\/span><\/p>\n

                                                          <\/p>\n

                                                          <\/p>\n

                                                          ALTER TABLE emp_hpart COALESCE PARTITION;
                                                          \n<\/span><\/p>\n


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

                                                          SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME HEADER_FILE HEADER_BLOCK
                                                          \n<\/span><\/p>\n

                                                          ————— ————— ————— ———– ————
                                                          \n<\/span><\/p>\n

                                                          EMP_HPART P1 DATA01 8 21
                                                          \n<\/span><\/p>\n

                                                          EMP_HPART P2 DATA02 9 2
                                                          \n<\/span><\/p>\n

                                                          EMP_HPART P3 DATA03 10 2
                                                          \n<\/span><\/p>\n


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

                                                          Oracle\uc740 \uc0c8\ub85c\uc6b4 P2 partition\uc744 \uc7ac \uc0dd\uc131\uc740 \ubb3c\ub860 P2\uc640 P4\uc758 row\uac00 \uc7ac \ubd84\ubc30\ub428\uc5d0 \uc720\uc758\ud558\ub77c.
                                                          \n<\/span><\/p>\n

                                                          \n

                                                          Index\uc758 \uc0c1\ud0dc
                                                          \n<\/span><\/h4>\n<\/p>\n
                                                            \n
                                                          1. \n
                                                            \uc120\ud0dd\ub41c partition\uc758 Local Index partition\ub294 \uc0ad\uc81c\ub41c\ub2e4.
                                                            \n<\/span><\/div>\n<\/li>\n
                                                          2. \n
                                                            \uc0ad\uc81c\ub41c Partition\uc758 data\uac00 \uc774\ub3d9\ud558\uac8c \ub418\ub294 Local Index\uc758 partition\uc740 ‘UNUSABLE’ \uc0c1\ud0dc\uac00 \ub418\ubbc0\ub85c rebuild\uac00 \ud544\uc694\ud558\ub2e4.
                                                            \n<\/span><\/div>\n<\/li>\n
                                                          3. \n
                                                            Global Index partition\uc804\uccb4\uac00 ‘UNUSABLE’ \uc0c1\ud0dc\uac00 \ub418\ubbc0\ub85c \ubaa8\ub4e0 partition\uc5d0 \ub300\ud55c rebuild\uac00 \ud544\uc694\ud558\ub2e4.
                                                            \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                            \n

                                                            \uc81c\uc57d \uc0ac\ud56d
                                                            \n<\/span><\/h4>\n<\/p>\n
                                                              \n
                                                            1. \n
                                                              Index\uc5d0 \ub300\ud574\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4.
                                                              \n<\/span><\/div>\n<\/li>\n
                                                            2. \n
                                                              Global index\uc778 \uacbd\uc6b0 \uc804\uccb4 partition\uc5d0 \ub300\ud55c rebuild\uac00 \ud544\uc694\ud558\ub2e4.
                                                              \n<\/span><\/div>\n<\/li>\n<\/ol>\n


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

                                                              \n

                                                              Partition\uc758 \ucd94\uac00\ub85c \uc778\ud55c \uc18d\uc131\uc758 \ubcc0\uacbd
                                                              \n<\/span><\/h3>\n<\/p>\n

                                                              Index\ub97c \uc0dd\uc131\ud560 \ub54c partition\uc758 \uc774\ub984\uacfc tablespace\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc73c\ub098 \uc790\ub3d9\uc801\uc73c\ub85c \uc0dd\uc131\ub418\ub294 Local index partition\uc758 \uacbd\uc6b0 \uc0c8\ub85c\uc6b4 table\uc758 partition\uacfc \ub3d9\uc77c\ud55c \uc774\ub984\uacfc tablespace\uc5d0 \uc0dd\uc131\ub41c\ub2e4. \uc774\ub7f0 \uacbd\uc6b0\ub294 \uc131\ub2a5, \uacf5\uac04\ud65c\uc6a9 \ub4f1\uc758 \ubb38\uc81c\ubc1c\uc0dd \uc5ec\uc9c0\uac00 \uc788\uc73c\ubbc0\ub85c \ubcc0\uacbd\ud558\uc5ec\uc57c \ud55c\ub2e4.
                                                              \n<\/span><\/p>\n

                                                                \n
                                                              1. \n
                                                                \uc0c8\ub85c \ucd94\uac00\ub41c Local Index\uc758 Tablespace\ub97c \ubcc0\uacbd\ud55c\ub2e4.
                                                                \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                ALTER INDEX emp_idx1 REBUILD PARTITION new_part_name
                                                                \n<\/span><\/p>\n

                                                                TABLESPACE index_tablespace_name;
                                                                \n<\/span><\/p>\n

                                                                  \n
                                                                1. \n
                                                                  \uc0c8\ub85c \ucd94\uac00\ub41c Local Index\uc758 \uc774\ub984\uc744 \ubcc0\uacbd\ud55c\ub2e4.
                                                                  \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                  ALTER INDEX emp_idx1 RENAME PARTITION new_part_name TO partition_name;<\/span>
                                                                  \n\t<\/span><\/p>\n


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

                                                                  \n

                                                                  Non-partition Table\uacfc Partition Table\uac04\uc758 \ubcc0\uacbd
                                                                  \n<\/span><\/h2>\n<\/p>\n

                                                                  Non-partition Table\uacfc Partition table\uc744 \uc0c1\ud638 \ubcc0\uacbd\ud558\ub294 3\uac00\uc9c0 \ubc29\ubc95\uc744 \uc124\uba85\ud55c\ub2e4.
                                                                  \n<\/span><\/p>\n


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

                                                                  \n

                                                                  Export \/ Import \uc0ac\uc6a9
                                                                  \n<\/span><\/h3>\n<\/p>\n

                                                                  \uc6d0\ubcf8 Table\uc744 export\ud558\uc5ec \ubaa9\ud45c Table\uc5d0 import \ud55c\ub2e4.
                                                                  \n<\/span><\/p>\n

                                                                  \n

                                                                  \uc218\ud589 \uc608\uc81c
                                                                  \n<\/span><\/h4>\n<\/p>\n
                                                                    \n
                                                                  1. \n
                                                                    \uc6d0\ubcf8 table export
                                                                    \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                    exp user\/passswd tables=table_name file=exp.dmp
                                                                    \n<\/span><\/p>\n

                                                                      \n
                                                                    1. \n
                                                                      \uc6d0\ubcf8 table \uc0ad\uc81c
                                                                      \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                      drop table table_name;
                                                                      \n<\/span><\/p>\n

                                                                        \n
                                                                      1. \n
                                                                        \ubaa9\ud45c Partition table\ub85c \uc0dd\uc131
                                                                        \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                        create table table_name (
                                                                        \n<\/span><\/p>\n

                                                                        qty number(3),
                                                                        \n<\/span><\/p>\n

                                                                        name varchar2(15))
                                                                        \n<\/span><\/p>\n

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

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

                                                                        partition p1 values less than (501),
                                                                        \n<\/span><\/p>\n

                                                                        partition p2 values less than (maxvalue)
                                                                        \n<\/span><\/p>\n

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

                                                                          \n
                                                                        1. \n
                                                                          ignore=y option\uc744 \uc0ac\uc6a9\ud558\uc5ec import
                                                                          \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                          imp user\/passwd file=exp.dmp ignore=y
                                                                          \n<\/span><\/p>\n

                                                                          ignore=y option\uc740 import\uc2dc\uc5d0 table creation\uc2dc \ubc1c\uc0dd\ud558\ub294 error\ub97c \ubb34\uc2dc\ud55c\ub2e4.
                                                                          \n<\/span><\/p>\n

                                                                          Non-partition Table\uacfc Partition table\uc744 \uc0c1\ud638 \ubcc0\uacbd\ud558\ub294 3\uac00\uc9c0 \ubc29\ubc95\uc744 \uc124\uba85\ud55c\ub2e4.
                                                                          \n<\/span><\/p>\n


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

                                                                          \n

                                                                          Sub query\ub97c \uc774\uc6a9\ud55c insert
                                                                          \n<\/span><\/h3>\n<\/p>\n

                                                                          \uc6d0\ubcf8 Table\uc744 select \ud558\uc5ec \ubaa9\ud45c Table\uc5d0 insert \ud55c\ub2e4.
                                                                          \n<\/span><\/p>\n

                                                                          \n

                                                                          \uc218\ud589 \uc608\uc81c
                                                                          \n<\/span><\/h4>\n<\/p>\n
                                                                            \n
                                                                          1. \n
                                                                            \ubaa9\ud45c Partition table\ub85c \uc0dd\uc131
                                                                            \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                            create table new_table (
                                                                            \n<\/span><\/p>\n

                                                                            qty number(3),
                                                                            \n<\/span><\/p>\n

                                                                            name varchar2(15))
                                                                            \n<\/span><\/p>\n

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

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

                                                                            partition p1 values less than (501),
                                                                            \n<\/span><\/p>\n

                                                                            partition p2 values less than (maxvalue)
                                                                            \n<\/span><\/p>\n

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

                                                                              \n
                                                                            1. \n
                                                                              \uc6d0\ubcf8 table\uc744 select\ud558\uc5ec \ubaa9\ud45c table\uc5d0 insert
                                                                              \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                              insert into new_table select * from org_table
                                                                              \n<\/span><\/p>\n

                                                                                \n
                                                                              1. \n
                                                                                \uc6d0\ubcf8 table \uc0ad\uc81c \ud6c4\uc5d0 \ubaa9\ud45c table\uc744 rename
                                                                                \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                                drop table org_table;
                                                                                \n<\/span><\/p>\n

                                                                                alter table new_table rename to org_table;
                                                                                \n<\/span><\/p>\n


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

                                                                                \n

                                                                                Partition exchange\uc774\uc6a9
                                                                                \n<\/span><\/h3>\n<\/p>\n

                                                                                Non-partition Table\uc774 Partition table\uc758 \ud558\ub098\uc758 partition\uc73c\ub85c \ubcc0\ud658\ub41c\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \ud558\ub098\uc758 non-partition table\ub85c \ud558\ub098\uc758 partition table\ub85c \ubcc0\ud658\uc744 \uc704\ud574\uc11c\ub294 \uc6d0\ubcf8 dummy table\uc744 \ud544\uc694\ub85c \ud55c\ub2e4.
                                                                                \n<\/span><\/p>\n

                                                                                <Partition\uc758 \uc791\uc5c5, Partition\uc758 \uad50\ud658 \ucc38\uace0>
                                                                                \n<\/span><\/p>\n

                                                                                \n

                                                                                \uc218\ud589 \uc608\uc81c
                                                                                \n<\/span><\/h4>\n<\/p>\n
                                                                                  \n
                                                                                1. \n
                                                                                  \ubaa9\ud45c Partition table\ub85c \uc0dd\uc131
                                                                                  \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                                  create table new_table (
                                                                                  \n<\/span><\/p>\n

                                                                                  qty number(3),
                                                                                  \n<\/span><\/p>\n

                                                                                  name varchar2(15))
                                                                                  \n<\/span><\/p>\n

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

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

                                                                                  partition p1 values less than (501),
                                                                                  \n<\/span><\/p>\n

                                                                                  partition p2 values less than (maxvalue)
                                                                                  \n<\/span><\/p>\n

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

                                                                                    \n
                                                                                  1. \n
                                                                                    \uc6d0\ubcf8 table\uacfc targer table\uc744 exchange
                                                                                    \n<\/span><\/div>\n<\/li>\n<\/ol>\n

                                                                                    CREATE TABLE dummy_y as SELECT sal FROM emp WHERE qty < 501;
                                                                                    \n<\/span><\/p>\n

                                                                                    CREATE TABLE dummy_z as SELECT sal FROM emp WHERE qty >= 501;
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE new_table EXCHANGE PARTITION p1 WITH TABLE dummy_y;
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE new_table EXCHANGE PARTITION p2 WITH TABLE dummy_z;<\/span>
                                                                                    \n\t<\/span><\/p>\n


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

                                                                                    \n

                                                                                    Partition Table\/Index\uc640 \uc5f0\uad00\ub41c DML
                                                                                    \n<\/span><\/h2>\n<\/p>\n

                                                                                    Partition Table\/Index\uc640 \uad00\ub828\ud55c DML\uc5d0 \ub300\ud558\uc5ec \uc124\uba85\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    Partition Key \uac12\uc758 update
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    Partition Key \uac12\uc758 \ubcc0\uacbd\uc740 row\uac00 \uc874\uc7ac\ud558\ub294 partition\uc744 \ubc14\ub00c\uc5b4\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4. Update\ud6c4\uc5d0\ub3c4 \ub3d9\uc77c\ud55c partition\uc5d0 \uc874\uc7ac\ud560 \uc218 \uc788\ub2e4\uba74 \uc0c1\uad00\uc5c6\uc9c0\ub9cc \ub2e4\ub978 partition\uc73c\ub85c \uc62e\uaca8\uc9c8 \ud544\uc694\uac00 \uc788\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4. \uc774\ub7f0 \uacbd\uc6b0\uc5d0 \ud574\ub2f9 Table\uc5d0 row movement\uac00 enable\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc73c\uba74 ORA-14402 error (updating partition key column would cause a partition change)\uac00 \ubc1c\uc0dd\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    \uc774 option\uc740 Partition Table\uc758 \uc0dd\uc131\uc2dc \ub610\ub294 \ub098\uc911\uc5d0 \ubcc0\uacbd\ud560 \uc218 \uc788\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    CREATE TABLE part_tab_name <\/span>\u2026<\/span>. ENABLE\/DISABLE ROW MOVEMENT;
                                                                                    \n<\/span><\/p>\n

                                                                                    \ub610\ub294
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE part_tab_name ENABLE\/DISABLE ROW MOVEMENT;
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    9i\uc758 List Partition
                                                                                    \n<\/span><\/h2>\n<\/p>\n

                                                                                    9i\uc758 \uc2e0\uae30\ub2a5\uc778 List Partition\uc758 command\uc5d0 \ub300\ud558\uc5ec \uc124\uba85\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    CREATE a List Partitioned Table
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    <\/p>\n

                                                                                    List Partition Table\uc744 \uc0dd\uc131\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    CREATE TABLE employees_reg_p
                                                                                    \n<\/span><\/p>\n

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

                                                                                    employee_id NUMBER(6)
                                                                                    \n<\/span><\/p>\n

                                                                                    , first_name VARCHAR2(20)
                                                                                    \n<\/span><\/p>\n

                                                                                    , last_name VARCHAR2(25) CONSTRAINT emp_last_name_nn_p NOT NULL
                                                                                    \n<\/span><\/p>\n

                                                                                    , email VARCHAR2(25) CONSTRAINT emp_email_nn_p NOT NULL
                                                                                    \n<\/span><\/p>\n

                                                                                    , phone_number VARCHAR2(20)
                                                                                    \n<\/span><\/p>\n

                                                                                    , hire_date DATE CONSTRAINT emp_hire_date_nn_p NOT NULL
                                                                                    \n<\/span><\/p>\n

                                                                                    , job_id VARCHAR2(10) CONSTRAINT emp_job_nn_p NOT NULL
                                                                                    \n<\/span><\/p>\n

                                                                                    , salary NUMBER(8,2) CONSTRAINT emp_salary_nn_p NOT NULL
                                                                                    \n<\/span><\/p>\n

                                                                                    , commission_pct NUMBER(2,2)
                                                                                    \n<\/span><\/p>\n

                                                                                    , manager_id NUMBER(8)
                                                                                    \n<\/span><\/p>\n

                                                                                    , department_id NUMBER(4)
                                                                                    \n<\/span><\/p>\n

                                                                                    , region VARCHAR2(15)
                                                                                    \n<\/span><\/p>\n

                                                                                    , CONSTRAINT emp_salary_min_p CHECK (salary > 0)
                                                                                    \n<\/span><\/p>\n

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

                                                                                    PCTFREE 60
                                                                                    \n<\/span><\/p>\n

                                                                                    partition BY LIST (REGION)
                                                                                    \n<\/span><\/p>\n

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

                                                                                    partition Zone_1 VALUES (‘R1’, ‘R10’, ‘R11’, ‘R12’) TABLESPACE ZONE1,
                                                                                    \n<\/span><\/p>\n

                                                                                    partition Zone_2 VALUES (‘R13’, ‘R14’, ‘R15’, ‘R16’)TABLESPACE ZONE2,
                                                                                    \n<\/span><\/p>\n

                                                                                    partition Zone_3 VALUES (‘R17’, ‘R18’, ‘R19’, ‘R2’) TABLESPACE ZONE3,
                                                                                    \n<\/span><\/p>\n

                                                                                    partition Zone_4 VALUES (‘R20’, ‘R21’, ‘R22’, ‘R23’)TABLESPACE ZONE4,
                                                                                    \n<\/span><\/p>\n

                                                                                    partition Zone_5 VALUES (‘R24’, ‘R25’, ‘R26’, ‘R27’)TABLESPACE ZONE5,
                                                                                    \n<\/span><\/p>\n

                                                                                    partition Zone_6 VALUES (‘R28’, ‘R29’, ‘R3’, ‘R30’) TABLESPACE ZONE6,
                                                                                    \n<\/span><\/p>\n

                                                                                    partition Zone_7 VALUES (‘R31’, ‘R32’, ‘R4’, ‘R5’) TABLESPACE ZONE7,
                                                                                    \n<\/span><\/p>\n

                                                                                    partition Zone_8 VALUES (‘R6’, ‘R7’, ‘R8’, ‘R9’) TABLESPACE ZONE8
                                                                                    \n<\/span><\/p>\n

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

                                                                                    – \ub2e4\uc74c\uc758 View\ub85c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    SELECT table_name, partition_name partition,
                                                                                    \n<\/span><\/p>\n

                                                                                    high_value, partition_position position
                                                                                    \n<\/span><\/p>\n

                                                                                    FROM user_tab_partitions
                                                                                    \n<\/span><\/p>\n

                                                                                    WHERE table_name = ‘EMPLOYEES_REG_P’;
                                                                                    \n<\/span><\/p>\n


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

                                                                                    TABLE_NAME PARTITION HIGH_VALUE POSITION
                                                                                    \n<\/span><\/p>\n

                                                                                    ————— ———- ——————————— ——–
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_1 ‘R1’, ‘R10’, ‘R11’, ‘R12’ 1
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_2 ‘R13’, ‘R14’, ‘R15’, ‘R16’ 2
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_3 ‘R17’, ‘R18’, ‘R19’, ‘R2’ 3
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_4 ‘R20’, ‘R21’, ‘R22’, ‘R23’ 4
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_5 ‘R24’, ‘R25’, ‘R26’, ‘R27’ 5
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_6 ‘R28’, ‘R29’, ‘R3’, ‘R30’ 6
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_7 ‘R31’, ‘R32’, ‘R4’, ‘R5’ 7
                                                                                    \n<\/span><\/p>\n

                                                                                    EMPLOYEES_REG_P ZONE_8 ‘R6’, ‘R7’, ‘R8’, ‘R9’ 8
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    MODIFY a List Partition
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    List Partition Table\uc758 partition key \uac12\uc744 \uc0ad\uc81c\ud55c\ub2e4. \uc0ad\uc81c\ud558\uace0\uc790 \ud558\ub294 Key value\uc5d0 \ud574\ub2f9\ud558\ub294 Row\ub97c \uc0ad\uc81c\ud55c \ud6c4 modify\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    DELETE employees_reg_p WHERE REGION IN (‘R32’, ‘R22’);
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE employees_reg_p MODIFY PARTITION zone_4
                                                                                    \n<\/span><\/p>\n

                                                                                    DROP values (‘R22’);
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE employees_reg_p MODIFY PARTITION zone_7
                                                                                    \n<\/span><\/p>\n

                                                                                    DROP values (‘R32’);
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    ADD a List Partition
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    List Partition Table\uc5d0 \uc0c8\ub85c\uc6b4 Partition\uc744 \ucd94\uac00\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE employees_reg_p ADD partition Zone_add values (‘R22’, ‘R32’);
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    MERGE List Partitions
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    List Partition Table\uc758 partition\ub4e4\uc744 \ud569\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE employees_reg_p MERGE PARTITIONS Zone_add, Zone_7 INTO
                                                                                    \n<\/span><\/p>\n

                                                                                    PARTITION Zone_7;
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    RENAME a List Partitions
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    List Partition Table\uc758 partition\uc758 \uc774\ub984\uc744 \ubcc0\uacbd\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE employees_reg_p RENAME PARTITION Zone_7 TO Zone_merge;
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    SPLIT a List Partition
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    List Partition Table\uc758 partition\uc744 \ub458\ub85c \ubd84\ud560\ud55c\ub2e4. Partition Zone_1\uc911\uc5d0\uc11c R11, R12\uac12\uc740 Zone_11\ub85c \ub098\uba38\uc9c0\ub294 Zone_12\ub85c \ubd84\ud560\ub41c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE employees_reg_p SPLIT PARTITION Zone_1 VALUES (‘R11’, ‘R12’)
                                                                                    \n<\/span><\/p>\n

                                                                                    INTO ( PARTITION Zone_11, PARTITION Zone_12);
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    TRUNCATE a List Partition
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    List Partition Table\uc758 partition\ub0b4\uc758 Data\ub97c \uc9c0\uc6b0\uace0 \ucd08\uae30\ud654\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n


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

                                                                                    ALTER TABLE employees_reg_p TRUNCATE PARTITION Zone_3 DROP STORAGE;
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    EXCHANGE a List Partition
                                                                                    \n<\/span><\/h3>\n<\/p>\n

                                                                                    Non Partition Table\uacfc Partition table\uc758 \ud558\ub098\uc758 partition\uacfc \uad50\ud658\ud55c\ub2e4.
                                                                                    \n<\/span><\/p>\n

                                                                                    ALTER TABLE employees_reg_p EXCHANGE PARTITION Zone_3
                                                                                    \n<\/span><\/p>\n

                                                                                    WITH TABLE exchange_zone_3
                                                                                    \n<\/span><\/p>\n

                                                                                    WITHOUT VALIDATION;
                                                                                    \n<\/span><\/p>\n


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

                                                                                    \n

                                                                                    \uacb0\ub860
                                                                                    \n<\/span><\/h2>\n<\/p>\n

                                                                                    Partitioning \uae30\ub2a5\uc740 \uc131\ub2a5\uacfc \uad00\ub9ac \uce21\uba74\uc5d0\uc11c \ud604\uc800\ud55c \ud5a5\uc0c1\ubfd0\ub9cc \uc544\ub2c8\ub77c data\uc758 \uad6c\uc131\uc5d0 \uc788\uc5b4 \ubcf4\ub2e4 \ub098\uc740 \uc720\uc5f0\uc131\uc744 \uc81c\uacf5\ud55c\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

                                                                                      Version 7 Partitioning\uc740 partition view\ub97c \ud1b5\ud574 V7.3\ubd80\ud130 \uac00\ub2a5\ud558\uc600\ub2e4. \uc774 view\ub294 \ub3d9\uc77c\ud55c \uad6c\uc870\ub97c \uac00\uc9c0\ub294 table\uc758 UNION ALL\uc5d0 \uae30\ubcf8\uc744 \ub450\uc5c8\uace0 column\uacfc type\uc774 \ub3d9\uc77c\ud558\uace0 \uac19\uc740 \uc21c\uc11c\ub97c \uac00\uc838\uc57c \ud55c\ub2e4. \ub354\uc6b1\uc774 \uac01 table\uc740 partition key\uc5d0 \ud574\ub2f9\ud558\ub294 index\ub97c \uac00\uc838\uc57c \ud55c\ub2e4. \uc870\uac74\uc744 \ub9cc\uc871\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc5d0\ub294 optimizer\uac00 execution plan\uc744 \uc138\uc6b8 \ub54c \uc2e4\ud328\ud558\uac8c \ub41c\ub2e4. Partition View table\uc758 UNION ALL view\ub85c \uc0dd\uc131\ub41c\ub2e4 Create view […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[727,728,729,730,731,315,732,99,733],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1302"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1302"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1302\/revisions"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}