<\/p>\n
Export\/Import\ub97c \uc774\uc6a9\ud558\uc5ec Data\ub97c \uc62e\uae30\uac70\ub098 Space\ub97c \uc815\ub9ac\ud560 \ub54c Table\uacfc Index\ub97c \uac01\uac01 \ub2e4\ub978 Tablespace\uc5d0 \ubd84\ub9ac\ud558\uc5ec \uc800\uc7a5\ud558\uae30\ub3c4 \ud55c\ub2e4. \uc774\ub7ec\ud55c \ubc29\ubc95\uc740 Oracle\uc758 \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ub370 \ub9ce\uc740 \ub3c4\uc6c0\uc744 \uc900\ub2e4.<\/p>\n
Import\ud560 \ub54c Table\uacfc Index\ub97c \uc0dd\uc131\uc2dc\ucf30\ub358 Script\ub97c \uac00\uc9c0\uace0 \uc788 \uba74 \ud3b8\ub9ac\ud558\uac8c \uc774 \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\ub2e4.<\/p>\n
\uba3c\uc800 Import\ud560 \ub54c Indexes=N option\uc744 \uc0ac\uc6a9\ud558\uc5ec Index\ub97c \uc81c\uc678\ud55c \ub098\uba38\uc9c0 Object\ub97c Import\ud558\uace0, Index\ub294 Script\uc5d0\uc11c Tablespace\ub97c \uc9c0\uc815\ud55c \ud6c4 SQL file\uc744 \uc2e4\ud589\uc2dc\ucf1c\uc11c \uc0dd\uc131\ud558\uba74 \ub41c\ub2e4. \uadf8\ub7ec\ub098 Index Script\ub97c \uac00\uc9c0\uace0 \uc788\uc9c0 \uc54a\uc744 \ub54c\ub294 \ubb38 \uac00 \ubcf5\uc7a1\ud574\uc9c4\ub2e4.<\/p>\n
\uadf8\ub7ec\ud55c \uacbd\uc6b0\uc5d0 Import Option\uc911\uc5d0\uc11c Indexfile Option\uc744 \uc0ac\uc6a9\ud558\uc5ec Index script\ub97c \ub9cc\ub4e4\uc5b4 \ub0bc \uc218\uac00 \uc788\ub2e4. \uc774 \ubc29\ubc95\uc740 Indexfile\ub9cc \ub9cc\ub4e4\uae30 \ub54c\ubb38\uc5d0 \uc18d\ub3c4\uac00 \ube60\ub974\uace0, Index \ubfd0\ub9cc\uc774 \uc544\ub2c8\ub77c Table Script\ub3c4 \ub9cc\ub4e4\uc5b4 \uc9c0\uae30 \ub54c\ubb38\uc5d0 \uacb0\uacfc\uc801\uc73c\ub85c Table Script\ub3c4 \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc774 \ub9cc\ub4e4 \uc218 \uc788\ub2e4.<\/p>\n
\ub2e4\uc74c \uc791\uc5c5\uc740 Scott User\uc758 \ubaa8\ub4e0 Data\ub97c Test User\ub85c \uc62e\uae30\uae30 \uc704\ud574\uc11c Export\/Import\ub97c \uc774\uc6a9\ud558\ub824\uace0 \ud55c\ub2e4. Import\uc2dc\uc5d0 Table\uacfc Index\ub294 Tablespace\ub97c \ub2e4\ub974\uac8c\ud558\uc5ec \uc800\uc7a5\ud55c\ub2e4.<\/p>\n
1. \ub2e4\uc74c\uacfc \uac19\uc774 Scott User\ub97c Export \ubc1b\ub294\ub2e4.<\/p>\n
$ exp scott\/tiger file=scott.dmp<\/p>\n
2. Export\ubc1b\uc740 File\uc5d0\uc11c Index\ub97c \uc81c\uc678\ud55c \ub098\uba38\uc9c0\ub9cc Import\ud55c\ub2e4.<\/p>\n
$ imp system\/manager file=scott.dmp fromuser=scott touser=test indexes=n commit=y<\/p>\n
\uc704\uc640 \uac19\uc774 \uc2e4\ud589\ud558\uba74 Test User\uc5d0\ub294 Index\ub97c \uc81c\uc678\ud55c \ub098\uba38\uc9c0 Object\ub9cc Import\ub41c\ub2e4.<\/p>\n
3. \uadf8\ub9ac\uace0 \ub2e4\uc74c\uacfc \uac19\uc774 Indexfile Option\uc744 \uc774\uc6a9\ud558\uc5ec Index Script\ub97c \ub9cc\ub4e0\ub2e4.<\/p>\n
$ imp system\/manager file=scott.dmp indexfile=index.sql<\/p>\n
\uc704\uc640 \uac19\uc774 \uba85\ub839\uc744 \uc2e4\ud589\ud558\uba74 \uc2e4\uc81c\ub85c Data\ub294 Import\ub418\uc9c0 \uc54a\uace0, index.sql\uc774\ub77c\ub294 File\ub9cc \ub9cc\ub4e4\uc5b4\uc9c4\ub2e4. \uadf8\ub9ac\uace0 \ud654\uc77c\uc744 VI \ub4f1\uc73c\ub85c \uc5f4\uc5b4\uc11c \ud655\uc778\ud574 \ubcf4\uba74 create table \ubb38\uc7a5\uacfc create index\ubb38\uc7a5\uc774 \uc788\uace0 Create Table \ubb38\uc7a5\uc740 REM\uc73c\ub85c \ub9c9\ud600 \uc788\uc5b4\uc11c \uacb0\uacfc\uc801\uc73c\ub85c Create Index\ubb38\ub9cc \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ub418\uc5b4 \uc788\ub2e4.<\/p>\n
\uc774 \ud654\uc77c\uc5d0\uc11c Create Index\ubb38\uc758 Tablespace\ub9cc \ubc14\uafb8\uc5b4\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 SQL*Plus\uc5d0\uc11c \uc2e4\ud589\uc2dc\ud0a8\ub2e4.<\/p>\n
$ sqlplus test\/test<\/p>\n
SQL> @index<\/p>\n
\uc774\ub807\uac8c \ud558\uc5ec Table\uacfc Index\ub97c \ub2e4\ub978 Tablespace\ub85c \ubd84\ub9ac\ud558\uc5ec \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\uc774 Indexfile option\uc740 Index\ub9cc\uc774 \uc544\ub2c8\ub77c Table \uc0dd\uc131\ubb38\uc7a5\uc774 \ud544\uc694\ud560 \ub54c\ub3c4 \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud558\uc5ec \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
Export\/Import\ub97c \uc774\uc6a9\ud558\uc5ec Data\ub97c \uc62e\uae30\uac70\ub098 Space\ub97c \uc815\ub9ac\ud560 \ub54c Table\uacfc Index\ub97c \uac01\uac01 \ub2e4\ub978 Tablespace\uc5d0 \ubd84\ub9ac\ud558\uc5ec \uc800\uc7a5\ud558\uae30\ub3c4 \ud55c\ub2e4. \uc774\ub7ec\ud55c \ubc29\ubc95\uc740 Oracle\uc758 \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ub370 \ub9ce\uc740 \ub3c4\uc6c0\uc744 \uc900\ub2e4. Import\ud560 \ub54c Table\uacfc Index\ub97c \uc0dd\uc131\uc2dc\ucf30\ub358 Script\ub97c \uac00\uc9c0\uace0 \uc788 \uba74 \ud3b8\ub9ac\ud558\uac8c \uc774 \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\ub2e4. \uba3c\uc800 Import\ud560 \ub54c Indexes=N option\uc744 \uc0ac\uc6a9\ud558\uc5ec Index\ub97c \uc81c\uc678\ud55c \ub098\uba38\uc9c0 Object\ub97c Import\ud558\uace0, Index\ub294 Script\uc5d0\uc11c Tablespace\ub97c \uc9c0\uc815\ud55c […]<\/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":[3],"tags":[673,863,864,865],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2662"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2662"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2662\/revisions"}],"predecessor-version":[{"id":2668,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2662\/revisions\/2668"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2662"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}