{"id":558,"date":"2015-11-04T08:56:48","date_gmt":"2015-11-04T08:56:48","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=558"},"modified":"2023-04-14T15:47:04","modified_gmt":"2023-04-14T06:47:04","slug":"oracle-datapump-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=558","title":{"rendered":"ORACLE DATAPUMP \uc815\ub9ac"},"content":{"rendered":"

\n <\/p>\n

Oracle 10g<\/em>\uc758 new feature\uc778 Data Pump\ub294 Oracle Database data\uc640 metadata\uc758 \uc774\ub3d9\uc744 \uc704\ud55c \ub9e4\uc6b0 \ube60\ub978 infrastructure\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4. \ub530\ub77c\uc11c Oracle 9i<\/em>\uae4c\uc9c0 \uc0ac\uc6a9\ub418\ub358 export, import utility\uc758 \ub354\uc6b1\ub354 \ud5a5\uc0c1\ub41c performance\ub97c \ubaa9\uc801\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc9c4 utility\uc774\ub2e4. \uae30\uc874\uc758 export, import\ub610\ud55c \uc9c0\uc6d0\ud558\ub294 Oracle 10g<\/em>\uc758 \uc2e0\uae30\ub2a5\uc778 Data Pump\uc758 \ud2b9\uc9d5\uc744 \uc9c0\uae08\ubd80\ud130 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4.\n<\/p>\n

\n\t<\/p>\n

\n

General Architecture
\n<\/h3>\n<\/p>\n

\n\t<\/p>\n

\uc5ec\uae30\uc11c\ub294 \uac04\ub7b5\ud558\uac8c Data Pump\uac00 \uc5b4\ub5a4 \ubc29\uc2dd\uc73c\ub85c \ub3d9\uc791\ud558\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4.\n<\/p>\n

    \n
  • \n
    Direct Path API(DPAPI) : Oracle Database 10g\ub294 \uae30\uc874\uc758 column array interface\ubfd0\ub9cc \uc544\ub2c8\ub77c stream interface\ub97c \uc9c0\uc6d0\ud558\uae30 \ub54c\ubb38\uc5d0, unload\ubc0f load time \uc2dc data conversion \ubc0f parsing\uc744 \ucd5c\uc18c\ud654\ud55c\ub2e4.\n<\/div>\n<\/li>\n
  • \n
    External Table Service: Data Pump\ub294 \ub2e4\uc74c\uc758 driver\ub97c \uc0ac\uc6a9\ud558\uc5ec external table\uc744 \uc0ac\uc6a9\ud55c\ub2e4.\n<\/div>\n
      \n
    • \n
      ORACLE_LOADER access driver : \uc774 driver\ub294 Oracle 9i\uc5d0\uc11c \ub098\uc628 \uac83\uc73c\ub85c SQL Loader compatible files\uc774 external table read-only access\ub97c \uc704\ud574 \uc81c\uacf5\ub41c\ub2e4.\n<\/div>\n<\/li>\n
    • \n
      ORACLE_DATAPUMP access driver : \uc774 driver\ub294 binary DPAPI streams\uc758 external table write & read access\ub97c \uc704\ud574 \uc81c\uacf5\ub418\ub294 \uc0c8\ub85c\uc6b4 access driver\uc774\ub2e4.\n<\/div>\n<\/li>\n<\/ul>\n<\/li>\n
    • \n
      DBMS_METADATA package\ub294 export worker process\ub97c \uc704\ud574 object definitions\uc744 \uc81c\uacf5\ud55c\ub2e4.\n<\/div>\n<\/li>\n
    • \n
      DBMS_DATAPUMP package\ub294 Oracle Database\uc758 data\uc640 metadata \uc774\ub3d9\uc744 \uc704\ud574 high-speed export & import API\ub97c \uc81c\uacf5\ud55c\ub2e4.\n<\/div>\n<\/li>\n
    • \n
      \uae30\uc874 \ubc84\uc804\uc758 SQL*Loader client\ub294 external table\ub85c \ud1b5\ud569\ub418\uc5b4, \uc790\ub3d9\uc801\uc73c\ub85c loader control file\uc774 external table access parameter\ub85c migration\ub41c\ub2e4.\n<\/div>\n<\/li>\n
    • \n
      \uc0c8\ub85c\uc6b4 export & import client(expdp & impdp)\ub294 Data Pump operation\uc758 \uc2dc\uc791\uacfc monitor\ub97c \uc704\ud574 DBMS_DATAPUMP package\ub97c \ubd80\ub974\ub294 \uc5ed\ud560\uc744 \ud55c\ub2e4.\n<\/div>\n<\/li>\n
    • \n
      Enterprise Manager, replication, transportable tablespaces\uac19\uc740 application\uc744 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 client\uc774\ub2e4.\n<\/div>\n<\/li>\n<\/ul>\n

      \n

      Data Pump\uc758 \uc8fc\uc694 \ud2b9\uc9d5
      \n<\/h3>\n<\/p>\n

      Data pump\uc758 \uc8fc\uc694 \ud2b9\uc9d5\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.\n<\/p>\n

        \n
      • \n
        Data access methods \uc120\ud0dd : direct-path or external tables \uc774\ub7ec\ud55c \uc120\ud0dd\uc740 data pump\uac00 \uc790\ub3d9\uc73c\ub85c \uc120\ud0dd\ud558\uc5ec \uc900\ub2e4.\n<\/div>\n<\/li>\n
      • \n
        \ud604\uc7ac \uc9c4\ud589\ub418\ub294 data pump job\uc5d0 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uc740 \ucc44\ub85c job\uc5d0 attach<\/span> , reattch<\/span>, or detach<\/span>\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
      • \n
        Version<\/span> parameter\ub97c \ud1b5\ud574 Oracle 9i<\/em>\uc758 exp\/imp\uc640 \ud638\ud658\ub41c\ub2e4.\n<\/div>\n<\/li>\n
      • \n
        Parallel<\/span> option\uc73c\ub85c \uc5ec\ub7ec \uac1c\uc758 thread\ub97c \ub744\uc6cc \uc880 \ub354 \ud6a8\uc728\uc801\uc778 \uc77c\ucc98\ub9ac\ub97c \ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
      • \n
        Estimate_only<\/span> parameter\ub97c \ud1b5\ud574 \uc2e4\uc81c \uc218\ud589\ud558\uc9c0 \uc54a\uace0\ub3c4, \uc5b4\ub290 \uc815\ub3c4\uc758 space\ub97c \uc694\uad6c\ud558\ub294\uc9c0 \uce21\uc815\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
      • \n
        Remote export \uc2dc\uc5d0\ub3c4 direct\ud55c \ubc29\ubc95\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n<\/ul>\n

        \n

        Data Pump\uc758 \uc0ac\uc6a9 \uc2dc \uc7a5\uc810
        \n<\/h3>\n<\/p>\n

        Data Pump\ub97c \uc0ac\uc6a9\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc787\uc810\uc774 \uc788\ub2e4.\n<\/p>\n

          \n
        • \n
          Direct-path\ub098 external table<\/span>\uacfc \uac19\uc774 data-access method\uac00 \uc790\ub3d9\uc801\uc73c\ub85c \uc120\ud0dd\ub41c\ub2e4.\n<\/div>\n<\/li>\n
        • \n
          \uc624\ub79c \uc2dc\uac04 \ub3d9\uc548 \uc2e4\ud589\ub418\ub294 job\uc5d0 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uace0 \uadf8 job\uc5d0 attach<\/span>\uc2dc\ucf1c \ub2e4\ub978 job\uc744 \uc2e4\ud589\uc2dc\ud0a4\uac70\ub098, detach<\/span>\uc2dc\ud0ac \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
        • \n
          EXCLUDE, INCLUDE, \uadf8\ub9ac\uace0 CONTENT<\/span> parameter\ub97c \uc0ac\uc6a9\ud558\uc5ec fine-grained object selection\uc744 \ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
        • \n
          Oracle 9i\ubd80\ud130 \uc81c\uacf5\ud574 \uc624\ub358 export & import\uc640\uc758 \ud638\ud658\uc744 \uc704\ud574 VERSION<\/span> parameter\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
        • \n
          PARALLEL<\/span> parameter\ub97c \uc0ac\uc6a9\ud558\uc5ec process \uc218\ub97c \uc81c\uc5b4\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
        • \n
          ESTIMATE_ONLY<\/span> parameter\ub97c \uc0ac\uc6a9\ud558\uc5ec, \uc2e4\ud589\uc2dc\ud0a4\uc9c0 \uc54a\uace0 \uc2dc\uac04\uc744 \uc608\uc0c1\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
        • \n
          Database link\ub97c \uc0ac\uc6a9\ud558\uc5ec remote database\uc5d0\uc11c direct\ub85c dump file\uc744 \uc0dd\uc131<\/span> \ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n<\/ul>\n

          \n <\/p>\n

          \n

          Data Pump Export Parameter
          \n<\/h3>\n<\/p>\n

          \uae30\uc874\uc758 original export parameter\uc640 10g<\/em>\uc758 \uc0c8\ub85c\uc6b4 parameter\ub97c \ud45c\ub97c \ud1b5\ud574 \ube44\uad50\ud574\ubcf4\uc790.\n<\/p>\n

          \n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
          \n

          Original Export<\/strong><\/span> <\/p>\n<\/td>\n

          		\n

          Data Pump Export<\/strong><\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          STATUS <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          DUMPFILE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          FILESIZE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          FLASHBACK_SCN <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          FLASHBACK_TIME <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          FULL <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          EXCLUDE and INCLUDE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          HELP <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          EXCLUDE and INCLUDE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          LOGFILE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          FLASHBACK_* <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          SCHEMAS <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          PARFILE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          QUERY <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

          ROWS=N<\/span> <\/p>\n<\/td>\n

          		\n

          CONTENT=METADATA_ONLY <\/p>\n<\/td>\n<\/tr>\n

          \n

          ROWS=Y<\/span> <\/p>\n<\/td>\n

          		\n

          CONTENT=ALL <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          TABLES <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          TABLESPACES <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          TRANSPORT_TABLESPACES <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          EXCLUDE and INCLUDE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          TRANSPORT_FULL_CHECK <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          FLASHBACK_SCN and\n<\/p>\n

          FLASHBACK_TIME <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          EXCLUDE and INCLUDE <\/p>\n<\/td>\n<\/tr>\n

          \n

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

          		\n

          None <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

          \uadf8\ub7ec\uba74, \uc0c8\ub85c\uc6b4 parameter\uac00 \uc5b4\ub5a4 \uae30\ub2a5\uc744 \ud558\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uc790.\n<\/p>\n

            \n
          • \n
            ATTACH<\/span> \ud604\uc7ac \uc874\uc7ac\ud558\ub294 exporting job\uc5d0 attach\ud558\uc5ec \uc5f0\uc18d\uc801\uc778 \uc77c\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\uac8c \ud574\uc900\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            CONTENT<\/span> \uc5b4\ub5a4 \uc790\ub8cc\ub4e4\uc744 unload\ud560 \uc9c0 \uacb0\uc815\ud560 \uc218 \uc788\ub294 parameter\ub85c DATA_ONLY<\/span>\uc77c \uacbd\uc6b0 table row data\ub9cc\uc744 unload\ud558\uba70, METADATA_ONLY<\/span>\uc77c \uacbd\uc6b0 table row data\ub294 unload\ud558\uc9c0 \uc54a\uace0 database object definition\ub9cc\uc744 unload\ud55c\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            DIRECTORY<\/span> \ud574\ub2f9 directory\uc5d0 unload\ub97c \uc9c4\ud589\ud55c\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            ESTIMATE<\/span> \uc2e4\uc81c unload\ub97c \ud558\uae30 \uc804 \uacbd\uc6b0 \uc5bc\ub9cc\ud07c\uc758 space\uac00 \uc0ac\uc6a9\ub420\uc9c0 \uce21\uc815\ud558\uba74\uc11c \uc218\ud589\ud560 \uc218 \uc788\ub2e4.parameter\ub85c \uce21\uc815 \ubc29\ubc95\uc740 BLOCKS, SAMPLING, STATS, NONE<\/span>\uc73c\ub85c \ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            ESTIMATE_ONLY<\/span> unload\ub97c \ud558\uc9c0 \uc54a\uace0 ESTIMATE\ub9cc\uc744 \ud560 \uc218 \uc788\ub294 parameter\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            EXCLUDE<\/span> \uc774 parameter\ub85c \uc120\ud0dd\ub41c \ubd80\ubd84\uc744 \uc81c\uc678\ud558\uace0 unload\uac00 \uac00\ub2a5\ud558\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            INCLUDE<\/span> \uc774 parameter\ub85c \uc120\ud0dd\ub41c \ubd80\ubd84\uc744 \ud3ec\ud568\ud558\uc5ec unload\uac00 \uac00\ub2a5\ud558\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            JOB_NAME<\/span> 30\uc790\uae4c\uc9c0 job name\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            KEEP_MASTER<\/span> export\uac00 \uc218\ud589\ub418\ub294 \ub3d9\uc548 master table\uc744 \uc720\uc9c0 \uad00\ub9ac\ud55c\ub2e4. Job\uc774 \ub05d\ub098\ub294 \uc2dc\uc810\uc5d0 import\ub97c \uc704\ud574 dump file\uc5d0 \uc774 \ub0b4\uc6a9\uc744 \ub123\uace0, database\uc5d0\uc11c\ub294 \uc774 table\uc744 drop\ud55c\ub2e4. KEEP_MASTER=Y<\/span>\ub85c \ub193\uc73c\uba74 \uc774 \ud14c\uc774\ube14\uc744 drop\ud558\uc9c0 \uc54a\uace0 debugging\uc774\ub098 custom report\ub97c \uc0dd\uc131\ud560 \ub54c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            NOLOGFILE<\/span> default\ub85c \uc0dd\uc131\ub418\ub294 log file\uc744 override\ud55c\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            PARALLEL<\/span> thread\uc758 maximum number\ub97c \uc9c0\uc815\ud574 \uc8fc\ub294 parameter\uc774\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            VERSION<\/span> \uc774\uc804 \ubc84\uc804\uc758 database\ub97c \uc704\ud55c compatibility\ub97c \uc81c\uacf5\ud574 \uc8fc\ub294 parameter\uc774\ub2e4.\n<\/div>\n<\/li>\n
          • \n
            NETWORK_LINK<\/span> database link\ub97c \ud1b5\ud574 network mode\ub85c \uc791\uc5c5\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n<\/ul>\n

            \ub610\ud55c interactive mode\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 parameter\ub4e4\uc774 \ucd94\uac00 \ub418\uc5c8\ub2e4.\n<\/p>\n

              \n
            • \n
              ADD_FILE<\/span> \ub2e4\ub978 \ud344\uc77c\uc744 \ub354\ud560\uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
            • \n
              CONTINUE_CLIENT<\/span> interactive-command mode\uc5d0\uc11c logging mode\ub85c \ubc14\uafc0\uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
            • \n
              EXIT_CLIENT<\/span> export client session\uc744 \uc911\uc9c0 \uc2dc\ud0a8\ub2e4. \uadf8\ub7ec\ub098 \ud604\uc7ac \ub3cc\uc544\uac00\uace0 \uc788\ub294 job\uc740 \uacc4\uc18d \uc218\ud589\ub41c\ub2e4.\n<\/div>\n<\/li>\n
            • \n
              KILL_JOB<\/span> \ubaa8\ub4e0 attached\ub41c job\uc744 detach\uc2dc\ud0a4\uace0 \ud604\uc7ac \ub3cc\uc544\uac00\uace0 \uc788\ub294 job\uc744 \uc911\uc9c0 \uc2dc\ud0a8\ub2e4.\n<\/div>\n<\/li>\n
            • \n
              PARALLEL<\/span> thread\ub97c \uc99d\uac00\uc2dc\ud0a4\uac70\ub098 \uc904\uc77c\uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
            • \n
              START_JOB <\/span>attach\ub418\uc5b4 \uc788\ub294 current job\uc744 \uc2dc\uc791\ud560 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
            • \n
              STOP_JOB<\/span> \ud604\uc7ac\uc758 job\uc744 \uc911\uc9c0 \uc2dc\ud0ac \uc218 \uc788\ub2e4. \uc774\ub807\uac8c \uc911\uc9c0\ub41c job\uc740 restart\uc2dc\ud0ac \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
            • \n
              STATUS<\/span> detailed status\ub97c \ubcfc \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n<\/ul>\n

              \n <\/p>\n

              \n

              Data Pump Import Parameter
              \n<\/h3>\n<\/p>\n

              \n <\/p>\n

              \n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
              \n

              Original Import<\/strong><\/span> <\/p>\n<\/td>\n

              		\n

              Data Pump Import<\/strong> <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              EXCLUDE and INCLUDE <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              TRANSPORT_DATAFILES <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              REUSE_DATAFILES <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              STATUS <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              DUMPFILE <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              SCHEMAS and\n<\/p>\n

              REMAP_SCHEMAS <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              FULL <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              EXCLUDE and INCLUDE <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              HELP<\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              TABLE_EXISTS_ACTION <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              SQLFILE <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              LOGFILE <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              PARFILE <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              QUERY <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

              ROWS=N<\/span> <\/p>\n<\/td>\n

              		\n

              CONTENT=METADATA_ONLY <\/p>\n<\/td>\n<\/tr>\n

              \n

              ROWS=Y<\/span> <\/p>\n<\/td>\n

              		\n

              CONTENT=ALL <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              SQLFILE <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              SKIP_UNUSABLE_INDEXES <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              TABLES <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              TABLESPACES <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              REMAP_SCHEMA <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              TRANSPORT_TABLESPACES <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n

              \n

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

              		\n

              None <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

              \uc0c8\ub85c\uc6b4 parameter\uc758 \uae30\ub2a5\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc790.\n<\/p>\n

                \n
              • \n
                FLASHBACK_SCN<\/span> flashback utility\uac00 \ub2e4\uc74c\uc758 SCN\uc73c\ub85c \uc801\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 parameter\uc774\ub2e4.\n<\/div>\n<\/li>\n
              • \n
                FLASHBACK_TIME<\/span> FLASHBACK_SCN\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 TIME\uc73c\ub85c \ud560 \uc218 \uc788\ub294 parameter\uc774\ub2e4.\n<\/div>\n<\/li>\n
              • \n
                REMAP_DATAFILE<\/span> import\uc2dc datafile\uc744 \ubcc0\uacbd\ud558\uc5ec \uc801\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc774 parameter\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 IMP_FULL_DATABASE<\/span> \uad8c\ud55c\uc774 \uc788\uc5b4\uc57c \ud55c\ub2e4.\n<\/div>\n<\/li>\n
              • \n
                REMAP_SCHEMA<\/span> \ud574\ub2f9 user\ub85c import\uc2dc\ud0ac \uc218 \uc788\ub294 parameter\uc774\ub2e4.\n<\/div>\n<\/li>\n
              • \n
                REMAP_TABLESPACE<\/span> tablespace\ub97c \ud574\ub2f9 parameter\ub85c \uc124\uc815\ud574 \uc904 \uc218 \uc788\ub2e4.\n<\/div>\n<\/li>\n
              • \n
                REUSE_DATAFILES<\/span> datafile\uc774 \uc788\uc744 \uc2dc\uc5d0 Y\ub85c \uc9c0\uc815\ud574 \uc8fc\uba74 \uac19\uc740 \uc774\ub984\uc73c\ub85c datafile\uc744 \uc7ac \uc0dd\uc131\ud574 \uc900\ub2e4. \uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc740 \uae30\uc874\uc758 data\ub294 \ub2e4 \uc5c6\uc5b4\uc9c4\ub2e4\ub294 \uc810\uc774\ub2e4.\n<\/div>\n<\/li>\n
              • \n
                SQLFILE<\/span> \ud574\ub2f9 file\uc5d0 import\uc2dc \uc218\ud589\ub418\ub294 DDL SQL\ubb38\uc774 \uc800\uc7a5\ub41c\ub2e4.\n<\/div>\n<\/li>\n
              • \n
                TABLE_EXISTS_ACTION<\/span> \ud574\ub2f9 table\uc774 \uc874\uc7ac\ud560 \uacbd\uc6b0 \uc5b4\ub5a4 \ucc98\ub9ac\uc808\ucc28\ub97c \uac70\uce60\uc9c0 \uc815\ud574\uc8fc\ub294 parameter\ub85c, SKIP<\/span>\uc740 \ub2e4\uc74c object\ub85c \ub118\uc5b4\uac00\uba70, APPEND<\/span>\ub294 \ud574\ub2f9 table\uc5d0 insert\ub97c \ud574\uc8fc\uba70, TRUNCATE<\/span>\ub294 \ud574\ub2f9 table\uc744 truncate\uc2dc\ud0a8 \ub2e4\uc74c load\uc2dc\ucf1c\uc8fc\uba70, REPLACE<\/span>\ub294 \ud574\ub2f9 table\uc744 drop and create\uc2dc\ud0a4\uace0 load\ud558\ub294 \uae30\ub2a5\uc774\ub2e4.\n<\/div>\n<\/li>\n<\/ul>\n

                \n <\/p>\n

                \n

                EXPDP TEST
                \n<\/h2>\n<\/p>\n

                \n

                \ud14c\uc2a4\ud2b8 \uac1c\uc694
                \n<\/h3>\n<\/p>\n

                \uae30\ubcf8\uc801\uc778 EXPDP test\ub97c \uc218\ud589\ud558\uc5ec expdp\uc758 \uae30\ub2a5\uc744 \uc0b4\ud3b4\ubcf4\uc790.\n<\/p>\n

                Text mode\ub85c \uc9c1\uc811 \uba85\ub839\uc744 \uc218\ud589\ud558\ub294 \ubc29\ubc95\uacfc Enterprise Manager\ub85c \uc2e4\ud589\ud558\ub294 \ub450 \uac00\uc9c0 \ubc29\ubc95\uc744 \ucc28\ub840\ub85c \ubcf4\uc5ec\uc904 \uc608\uc815\uc774\ub2e4.\n<\/p>\n

                \n

                \ud14c\uc2a4\ud2b8 \ud658\uacbd
                \n<\/h3>\n<\/p>\n

                \ud14c\uc2a4\ud2b8\uc5d0 \uc0ac\uc6a9\ub41c database version \uc815\ubcf4\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. \uc774\uc804 \ubc84\uc804\uc758 \uc81c\ud488\uc73c\ub85c \ud55c \ud14c\uc2a4\ud2b8\ub3c4 \ud3ec\ud568\ub418\uc5b4 \uc788\ub2e4.\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                select * from v$version;<\/span>
                \n\t\t\t\t\t\t\t<\/span><\/p>\n

                \n <\/p>\n

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

                Oracle10i Enterprise Edition Release 10.1.0.1.0 – Beta
                \n<\/span><\/p>\n

                PL\/SQL Release 10.1.0.1.0 – Beta
                \n<\/span><\/p>\n

                CORE 10.1.0.1.0 Beta
                \n<\/span><\/p>\n

                TNS for Solaris: Version 10.1.0.1.0 – Beta
                \n<\/span><\/p>\n

                NLSRTL Version 10.1.0.1.0 – Beta
                \n<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \n <\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                SQL> select * from v$version;<\/span>
                \n\t\t\t\t\t\t\t<\/span><\/p>\n

                \n <\/p>\n

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

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

                Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 – 64bi
                \n<\/span><\/p>\n

                PL\/SQL Release 10.1.0.2.0 – Production
                \n<\/span><\/p>\n

                CORE 10.1.0.2.0 Production
                \n<\/span><\/p>\n

                TNS for Solaris: Version 10.1.0.2.0 – Production
                \n<\/span><\/p>\n

                NLSRTL Version 10.1.0.2.0 – Production
                \n<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \n <\/p>\n

                Data pump\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 external file system\uc758 \uacbd\ub85c\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uc815\ud558\uc600\ub2e4.\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                SQL> create directory data_pump_dir as ‘C:\\Download’;
                \n<\/span><\/span><\/p>\n

                \n <\/p>\n

                \ub514\ub809\ud1a0\ub9ac\uac00<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span>.
                \n<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \n <\/p>\n

                \n

                \ud14c\uc2a4\ud2b81-1 Text mode\ub97c \ud1b5\ud55c expdp \ud14c\uc2a4\ud2b8
                \n<\/h3>\n<\/p>\n

                SCOTT\uc720\uc800\uc758 \ud14c\uc774\ube14 \uc804\uccb4\ub97c unload\ud558\ub294 schema level expdp\ub97c \uc2e4\ud589\ud574 \ubcf4\uaca0\ub2e4.\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                C:\\Download>expdp system\/manager schemas=scott directory=data_pump_dir DUMPFILE=exp1.dmp,exp2%U.dmp<\/span>
                \n\t\t\t\t\t\t\t<\/span><\/p>\n

                \n <\/p>\n

                Export: Release 10.1.0.1.0 – Beta on <\/span>\uae08\uc694\uc77c<\/span>, 05 12<\/span>\uc6d4<\/span>, 2003 11:20
                \n<\/span><\/span><\/p>\n

                \n <\/p>\n

                Copyright (c) 2003, Oracle. All rights reserved.
                \n<\/span><\/p>\n

                \n <\/p>\n

                Connected to: Oracle10i Enterprise Edition Release 10.1.0.1.0 – Beta
                \n<\/span><\/p>\n

                With the Partitioning, OLAP and Data Mining options
                \n<\/span><\/p>\n

                FLASHBACK<\/span>\uc740<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ubb34\uacb0\uc131\uc744<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc704\ud574<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc790\ub3d9\uc73c\ub85c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ud65c\uc131\ud654\ub429\ub2c8\ub2e4<\/span>.
                \n<\/span><\/span><\/p>\n

                “SYSTEM”.”SYS_EXPORT_SCHEMA_01″ <\/span>\uc2dc\uc791<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>: system\/******** schemas=scott directory
                \n<\/span><\/span><\/p>\n

                =data_pump_dir DUMPFILE=exp1.dmp,exp2%U.dmp
                \n<\/span><\/p>\n

                BLOCKS <\/span>\uba54\uc18c\ub4dc\ub97c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc0ac\uc6a9\ud558\uc5ec<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc608\uce21<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc9c4\ud589<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>…
                \n<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/TABLE_DATA <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                BLOCKS <\/span>\uba54\uc18c\ub4dc\ub97c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc0ac\uc6a9\ud55c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ucd1d<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc608\uce21<\/span>: 160.3 MB
                \n<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/USER <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/SYSTEM_GRANT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/ROLE_GRANT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/DEFAULT_ROLE <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/SE_PRE_SCHEMA_PROCOBJACT\/PROCACT_SCHEMA <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/TABLE <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”TEST1″ 133.5 MB 500000<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc5d1\uc2a4\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”BONUS” 0 KB 0<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc5d1\uc2a4\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”DEPT” 3.656 KB 4<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc5d1\uc2a4\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”EMP” 5.820 KB 14<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc5d1\uc2a4\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”SALGRADE” 3.585 KB 5<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc5d1\uc2a4\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”TEST” 0 KB 0<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc5d1\uc2a4\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \ub9c8\uc2a4\ud130<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ud14c\uc774\ube14<\/span> “SYSTEM”.”SYS_EXPORT_SCHEMA_01″<\/span>\uc774<\/span>(<\/span>\uac00<\/span>) <\/span>\uc131\uacf5\uc801\uc73c\ub85c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ub85c\ub4dc\ub428<\/span>\/<\/span>\ub85c\ub4dc<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ucde8\uc18c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

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

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

                SYSTEM.SYS_EXPORT_SCHEMA_01<\/span>\uc5d0<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ub300\ud574<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc124\uc815\ub41c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ub364\ud504<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ud30c\uc77c<\/span>:
                \n<\/span><\/span><\/p>\n

                C:\\DOWNLOAD\\EXP1.DMP
                \n<\/span><\/p>\n

                C:\\DOWNLOAD\\EXP201.DMP
                \n<\/span><\/p>\n

                “SYSTEM”.”SYS_EXPORT_SCHEMA_01″ <\/span>\uc791\uc5c5\uc774<\/span> 11:22<\/span>\uc5d0\uc11c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc131\uacf5\uc801\uc73c\ub85c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc644\ub8cc\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n


                \n\t\t\t\t\t\t\t<\/span> <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \n <\/p>\n

                \n

                \ud14c\uc2a4\ud2b81-2 Enterprise Manager\ub97c \ud1b5\ud55c expdp \ud14c\uc2a4\ud2b8
                \n<\/h3>\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 1> \uc704\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 system \uc720\uc800\ub85c \uc811\uc18d\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 2> system \uc720\uc800\ub85c \uc811\uc18d\ud55c \ub2e4\uc74c \ud574\ub2f9 schema\uc758 \uc885\uc18d\uc131\uc744 \uac80\uc0ac\ud558\uae30 \uc704\ud574 administrator\ub85c \uac04\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 3> Administrator\uc5d0\uc11c schema\uc758 table\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 4> \uc774\ud6c4 TEST1 table\uc744 \uc120\ud0dd\ud558\uc5ec \uc885\uc18d\uc131 \ud45c\uc2dc\ub97c \uc120\ud0dd\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 5> scott\uc720\uc800\uc758 test1 table\uc758 \uc885\uc18d\uc131\uc774 \uc704\uc640 \uac19\uc774 \ub098\uc628\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 6> \uadf8\ub9bc5\uc5d0\uc11c\uc640 \uac19\uc774 \uc885\uc18d\uc131\uc744 \uc0b4\ud3b4\ubcf8 \ub2e4\uc74c, \uadf8\ub9bc2\uc5d0\uc11c maintenance\ub85c \ub4e4\uc5b4\uac04 \ud6c4 export\ub97c \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 7> database user\uac00 \uc544\ub2cc OS user\ub85c \uc811\uc18d\ud558\uc5ec \uc778\uc99d\uc744 \ubc1b\ub294\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 8> \uc6d0\ud558\ub294 schema\ub97c \ucd94\uac00\ud558\uae30 \uc704\ud574 \ucd94\uac00 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 9> \uadf8\ub9bc\uacfc \uac19\uc774 scott user\ub97c \uc120\ud0dd\ud55c \ub2e4\uc74c \uc120\ud0dd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 10> \uadf8\ub9bc 8\uc5d0\uc11c scott\uc774 \ucd94\uac00\ub41c \ud654\uba74\uc744 \ubcfc \uc218 \uc788\ub2e4. \ub2e4\uc74c\uc744 \ud074\ub9ad\ud558\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 11> \ube14\ub85d\uc73c\ub85c \ub514\uc2a4\ud06c \uacf5\uac04 \uc608\uce21\uc744 \ud558\uc790. \ub2e4\uc74c\uc744 \ud074\ub9ad\ud558\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 12> \uae30\uc874\uc5d0 \ub9cc\ub4e4\uc5b4 \ub193\uc740 data_pump_dir\uc774 \uc120\ud0dd\ub418\uc5b4 \uc788\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \ub2e4\uc74c\uc744 \ud074\ub9ad\ud558\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 13> \uc791\uc5c5 \uc774\ub984\uc744 \uc368\ub193\uace0 \uc989\uc2dc \uc2dc\uc791\ud558\uac8c \ub9cc\ub4e4\uc5b4 \ub193\uc740 \ub2e4\uc74c, \ub2e4\uc74c\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 14> \ucd5c\uc885\uc73c\ub85c \uc791\uc5c5\uc744 \uac80\ud1a0\ud55c \ud6c4, \uc791\uc5c5 \uc81c\ucd9c\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 15> \uadf8\ub9bc\uacfc \uac19\uc774 \uc791\uc5c5 \uc81c\ucd9c\uc774 \uc131\uacf5\ud568\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \uc791\uc5c5 \ubcf4\uae30\ub97c \ud074\ub9ad\ud574\ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 16> \uc791\uc5c5\uc774 \uc9c4\ud589\uc911\uc784\uc744 \ud655\uc778 \ud560 \uc218 \uc788\ub2e4. \ub370\uc774\ud130 \ud38c\ud504 \uc791\uc5c5 \ubaa8\ub2c8\ud130\ub97c \ud074\ub9ad\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 17> \uc644\ub8cc\uc728\uacfc \uac19\uc740 \uc791\uc5c5 \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud560 \uc218 \uc788\ub2e4. \ud655\uc778\uc744 \ud074\ub9ad\ud558\uc5ec \uc804 \ud398\uc774\uc9c0\ub85c \ub3cc\uc544\uac00 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 18> \uc791\uc5c5\uc774 \uc644\ub8cc\ub428\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \uadf8\ub9bc 13\uc5d0\uc11c \ub9cc\ub4e0 \uc791\uc5c5 \uc774\ub984\uc744 \ub530\ub77c \ub85c\uadf8\ub97c \ud655\uc778\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 19> expdp\uac00 \ub9cc\ub4e4\uc5b4 \ub0b8 \ub85c\uadf8\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub2e4.\n<\/p>\n

                \n

                \ud14c\uc2a4\ud2b81-3 Interactive mode Expdp Test
                \n<\/h3>\n<\/p>\n

                \ud55c \ucabd\uc5d0\uc11c\ub294 expdp\ub97c \uc2e4\ud589\ud558\uba74\uc11c \ub2e4\ub978 \ud55c\ucabd\uc5d0\uc11c\ub294 \ud574\ub2f9 job\uc744 monitoring\ud558\uba70, \uadf8 job\uc744 \uba48\ucd94\uace0 \ub2e4\uc2dc \uc2dc\uc791\ud558\ub294 test\ub97c \ud574\ubcf4\uaca0\ub2e4.\n<\/p>\n

                \uc6b0\uc120 \ucc98\uc74c test\uc640 \uac19\uc740 \uba85\ub839\uc744 \ud55c \ucabd \ucc3d\uc5d0\uc11c \uc218\ud589\uc2dc\ud0a4\uba70, \uc544\ub798\uc640 \uac19\uc774 \uc2e4\ud589\ub41c \uc2dc\uc810\uc5d0 \ub2e4\ub978 \ucc3d\uc744 \ub744\uc6cc\uc11c \uc2e4\ud589 \uc2dc\ud0a4\ubcf8\ub2e4.\n<\/p>\n

                <\ucc3d-1>\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                oracle@krrac1=RASM1:\/oracle\/download>
                \n<\/span><\/p>\n

                $ expdp system\/oracle schemas=scott directory=data_pump_dir DUMPFILE=exp1.dmp
                \n<\/span><\/span><\/p>\n

                \n <\/p>\n

                Export: Release 10.1.0.2.0 – 64bit Production on Thursday, 04 March, 2004 14:10
                \n<\/span><\/p>\n

                \n <\/p>\n

                Copyright (c) 2003, Oracle. All rights reserved.
                \n<\/span><\/p>\n

                \n <\/p>\n

                Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 – 64bit Production
                \n<\/span><\/p>\n

                With the Partitioning, Real Application Clusters, OLAP and Data Mining options
                \n<\/span><\/p>\n

                FLASHBACK automatically enabled to preserve database integrity.
                \n<\/span><\/p>\n

                Starting “SYSTEM”.”SYS_EXPORT_SCHEMA_02<\/span>“: system\/******** schemas=scott directory=data_pump_dir DU
                \n<\/span><\/p>\n

                Estimate in progress using BLOCKS method…
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA
                \n<\/span><\/p>\n

                Total estimation using BLOCKS method: 128.3 MB
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/USER<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \n <\/p>\n

                \uc704\uc5d0\uc11c\uc640 \uac19\uc774 job_name\uc744 attach\uc5d0 \ubd99\uc5ec\uc11c expdp\ub97c \uc2e4\ud589\ud560 \uacbd\uc6b0, \ud574\ub2f9 job\uc758 status\ub97c \ubcf4\uc5ec\uc8fc\uba74\uc11c interactive command mode\ub85c \ub4e4\uc5b4\uac04\ub2e4. \uac70\uae30\uc11c status\ub97c \ud655\uc778\ud55c \ub2e4\uc74c, \ud574\ub2f9 job\uc744 stop \uc2dc\ucf1c\ubcf4\ub3c4\ub85d \ud558\uc790.\n<\/p>\n

                <\ucc3d-2>\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                oracle@krrac1=RASM1:\/oracle\/download>
                \n<\/span><\/p>\n

                $ expdp system\/oracle attach=SYS_EXPORT_SCHEMA_02
                \n<\/span><\/span><\/span><\/p>\n

                \n <\/p>\n

                Export: Release 10.1.0.2.0 – 64bit Production on Thursday, 04 March, 2004 14:11
                \n<\/span><\/p>\n

                \n <\/p>\n

                Copyright (c) 2003, Oracle. All rights reserved.
                \n<\/span><\/p>\n

                \n <\/p>\n

                Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 – 64bit Production
                \n<\/span><\/p>\n

                With the Partitioning, Real Application Clusters, OLAP and Data Mining options
                \n<\/span><\/p>\n

                \n <\/p>\n

                Job: SYS_EXPORT_SCHEMA_02
                \n<\/span><\/p>\n

                Owner: SYSTEM
                \n<\/span><\/p>\n

                Operation: EXPORT
                \n<\/span><\/p>\n

                Creator Privs: FALSE
                \n<\/span><\/p>\n

                GUID: D4C8392075663C8AE034080020E5BAD9
                \n<\/span><\/p>\n

                Start Time: Thursday, 04 March, 2004 14:10
                \n<\/span><\/p>\n

                Mode: SCHEMA
                \n<\/span><\/p>\n

                Instance: RASM1
                \n<\/span><\/p>\n

                Max Parallelism: 1
                \n<\/span><\/p>\n

                EXPORT Job Parameters:
                \n<\/span><\/p>\n

                Parameter Name Parameter Value:
                \n<\/span><\/p>\n

                CLIENT_COMMAND system\/******** schemas=scott directory=data_pump_dir DUMPFILE=exp1.dmp
                \n<\/span><\/p>\n

                DATA_ACCESS_METHOD AUTOMATIC
                \n<\/span><\/p>\n

                ESTIMATE BLOCKS
                \n<\/span><\/p>\n

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

                LOG_FILE_DIRECTORY DATA_PUMP_DIR
                \n<\/span><\/p>\n

                LOG_FILE_NAME export.log
                \n<\/span><\/p>\n

                TABLE_CONSISTENCY 0
                \n<\/span><\/p>\n

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

                State: EXECUTING
                \n<\/span><\/p>\n

                Bytes Processed: 0
                \n<\/span><\/p>\n

                Current Parallelism: 1
                \n<\/span><\/p>\n

                Job Error Count: 0
                \n<\/span><\/p>\n

                Dump File: \/oracle\/download\/exp1.dmp
                \n<\/span><\/p>\n

                bytes written: 4,096
                \n<\/span><\/p>\n

                \n <\/p>\n

                Worker 1 Status:
                \n<\/span><\/p>\n

                State: EXECUTING
                \n<\/span><\/p>\n

                \n <\/p>\n

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

                Are you sure you wish to stop this job ([y]\/n): yes
                \n<\/span><\/p>\n

                \n <\/p>\n

                oracle@krrac1=RASM1:\/oracle\/download>
                \n<\/span><\/p>\n

                $<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \uc704\uc640 \uac19\uc774 \ud574\ub2f9 job\uc744 stop \uc2dc\ud0a4\uba74 \uc2e4\ud589\ub418\uace0 \uc788\ub358 <\ucc3d-1>\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec \uba54\uc2dc\uc9c0\uac00 \ub098\ud0c0\ub09c\ub2e4.\n<\/p>\n

                <\ucc3d-1>\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                oracle@krrac1=RASM1:\/oracle\/download>
                \n<\/span><\/p>\n

                $ expdp system\/oracle schemas=scott directory=data_pump_dir DUMPFILE=exp1.dmp
                \n<\/span><\/p>\n

                \n <\/p>\n

                Export: Release 10.1.0.2.0 – 64bit Production on Thursday, 04 March, 2004 14:10
                \n<\/span><\/p>\n

                \n <\/p>\n

                Copyright (c) 2003, Oracle. All rights reserved.
                \n<\/span><\/p>\n

                \n <\/p>\n

                Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 – 64bit Production
                \n<\/span><\/p>\n

                With the Partitioning, Real Application Clusters, OLAP and Data Mining options
                \n<\/span><\/p>\n

                FLASHBACK automatically enabled to preserve database integrity.
                \n<\/span><\/p>\n

                Starting “SYSTEM”.”SYS_EXPORT_SCHEMA_02″: system\/******** schemas=scott directory=data_pump_dir DU
                \n<\/span><\/p>\n

                Estimate in progress using BLOCKS method…
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA
                \n<\/span><\/p>\n

                Total estimation using BLOCKS method: 128.3 MB
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/USER
                \n<\/span><\/p>\n

                Job “SYSTEM”.”SYS_EXPORT_SCHEMA_02″ stopped due to fatal error at 14:11
                \n<\/span><\/p>\n

                \n <\/p>\n

                oracle@krrac1=RASM1:\/oracle\/download>
                \n<\/span><\/p>\n

                $<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \uadf8\ub7ec\uba74 <\ucc3d-2>\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 job\uc774 \uba48\ucd94\uc5b4 \uc788\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, \uadf8 job\uc744 \ub2e4\uc2dc \uc2e4\ud589 \uc2dc\ud0ac \uc218 \uc788\ub2e4.\n<\/p>\n

                <\ucc3d-2>\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                oracle@krrac1=RASM1:\/oracle\/download>
                \n<\/span><\/p>\n

                $ expdp system\/oracle attach=SYS_EXPORT_SCHEMA_02
                \n<\/span><\/span><\/p>\n

                \n <\/p>\n

                Export: Release 10.1.0.2.0 – 64bit Production on Thursday, 04 March, 2004 14:14
                \n<\/span><\/p>\n

                \n <\/p>\n

                Copyright (c) 2003, Oracle. All rights reserved.
                \n<\/span><\/p>\n

                \n <\/p>\n

                Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 – 64bit Production
                \n<\/span><\/p>\n

                With the Partitioning, Real Application Clusters, OLAP and Data Mining options
                \n<\/span><\/p>\n

                \n <\/p>\n

                Job: SYS_EXPORT_SCHEMA_02
                \n<\/span><\/p>\n

                Owner: SYSTEM
                \n<\/span><\/p>\n

                Operation: EXPORT
                \n<\/span><\/p>\n

                Creator Privs: FALSE
                \n<\/span><\/p>\n

                GUID: D4C8392075663C8AE034080020E5BAD9
                \n<\/span><\/p>\n

                Start Time: Thursday, 04 March, 2004 14:14
                \n<\/span><\/p>\n

                Mode: SCHEMA
                \n<\/span><\/p>\n

                Instance: RASM1
                \n<\/span><\/p>\n

                Max Parallelism: 1
                \n<\/span><\/p>\n

                EXPORT Job Parameters:
                \n<\/span><\/p>\n

                Parameter Name Parameter Value:
                \n<\/span><\/p>\n

                CLIENT_COMMAND system\/******** schemas=scott directory=data_pump_dir DUMPFILE=exp1.dmp
                \n<\/span><\/p>\n

                DATA_ACCESS_METHOD AUTOMATIC
                \n<\/span><\/p>\n

                ESTIMATE BLOCKS
                \n<\/span><\/p>\n

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

                LOG_FILE_DIRECTORY DATA_PUMP_DIR
                \n<\/span><\/p>\n

                LOG_FILE_NAME export.log
                \n<\/span><\/p>\n

                TABLE_CONSISTENCY 0
                \n<\/span><\/p>\n

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

                State: IDLING
                \n<\/span><\/p>\n

                Bytes Processed: 0
                \n<\/span><\/p>\n

                Current Parallelism: 1
                \n<\/span><\/p>\n

                Job Error Count: 0
                \n<\/span><\/p>\n

                Dump File: \/oracle\/download\/exp1.dmp
                \n<\/span><\/p>\n

                bytes written: 4,096
                \n<\/span><\/p>\n

                \n <\/p>\n

                Worker 1 Status:
                \n<\/span><\/p>\n

                State: UNDEFINED
                \n<\/span><\/span><\/p>\n

                \n <\/p>\n

                Export> start_job
                \n<\/span><\/span><\/p>\n

                \n <\/p>\n

                Export> continue_client
                \n<\/span><\/span><\/p>\n

                Job SYS_EXPORT_SCHEMA_02 has been reopened at Thursday, 04 March, 2004 14:14
                \n<\/span><\/p>\n

                Restarting “SYSTEM”.”SYS_EXPORT_SCHEMA_02″: system\/******** schemas=scott directory=data_pump_dir
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/USER
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/SYSTEM_GRANT
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/ROLE_GRANT
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/DEFAULT_ROLE
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/SE_PRE_SCHEMA_PROCOBJACT\/PROCACT_SCHEMA
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/TABLE
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS
                \n<\/span><\/p>\n

                Processing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT
                \n<\/span><\/p>\n

                . . exported “SCOTT”.”EK_TEST” 108.9 MB 2752512 rows
                \n<\/span><\/p>\n

                . . exported “SCOTT”.”TEST” 67.62 KB 1000 rows
                \n<\/span><\/p>\n

                . . exported “SCOTT”.”DEPT” 5.656 KB 4 rows
                \n<\/span><\/p>\n

                . . exported “SCOTT”.”EMP” 7.820 KB 14 rows
                \n<\/span><\/p>\n

                . . exported “SCOTT”.”SALGRADE” 5.585 KB 5 rows
                \n<\/span><\/p>\n

                . . exported “SCOTT”.”BONUS” 0 KB 0 rows
                \n<\/span><\/p>\n

                . . exported “SCOTT”.”TST” 0 KB 0 rows
                \n<\/span><\/p>\n

                Master table “SYSTEM”.”SYS_EXPORT_SCHEMA_02″ successfully loaded\/unloaded
                \n<\/span><\/p>\n

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

                Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:
                \n<\/span><\/p>\n

                \/oracle\/download\/exp1.dmp<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \uadf8\ub7ec\uba74 \uc704\uc640 \ub611 \uac19\uc740 \ud14c\uc2a4\ud2b8\ub97c EM\uc5d0\uc11c \uc2e4\uc81c\ub85c \ud574\ubcf4\uaca0\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 1> \uc704\uc640 \uac19\uc774 \ud30c\uc77c\ub85c \uc5d1\uc2a4\ud3ec\ud2b8\ub97c \uc120\ud0dd\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 2> \uc704\uc640 \uac19\uc774 \uc2a4\ud0a4\ub9c8\ub97c \uc120\ud0dd\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 3> \uc5ec\uae30\uc11c \uc2a4\ud0a4\ub9c8 \ucd94\uac00 \ubc84\ud2bc\uc744 \ub204\ub978\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 4> SCOTT\uc744 \uc120\ud0dd\ud558\uc5ec \uc120\ud0dd \ubc84\ud2bc\uc744 \ub204\ub978\ub2e4.\n<\/p>\n

                \n <\/p>\n

                \n <\/p>\n

                \n <\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 5> SCOTT\uc774 \uc120\ud0dd\ub41c \ud6c4 \ub2e4\uc74c\uc744 \ub204\ub978\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 6> \uc6d0\ud558\ub294 \ub514\ub809\ud1a0\ub9ac\ub97c \uc120\ud0dd\ud558\uc5ec \ub2e4\uc74c\uc744 \uc120\ud0dd\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 7> dump\ub97c \ud560 \ub514\ub809\ud1a0\ub9ac\ub97c \uc120\ud0dd\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 8> \uc6d0\ud558\ub294 \uc791\uc5c5 \uc774\ub984\uc744 \uc801\uc740 \ud6c4 \uc989\uc2dc \uc2e4\ud589\uc744 \uc120\ud0dd\ud558\uc5ec \ub2e4\uc74c\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 9> \ucd5c\uc885 \uc81c\ucd9c\ud560 \uc791\uc5c5\uc744 \uac80\ud1a0\ud55c \ud6c4 \uc791\uc5c5 \uc81c\ucd9c\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 10> \uc791\uc5c5 \uc81c\ucd9c \uc911\uc778 \ud654\uba74\uc774 \ub72c\ub2e4. \uace7 \uc791\uc5c5 \uc81c\ucd9c \uc131\uacf5 \ud654\uba74\uc774 \ub72c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 11> \uc791\uc5c5 \uc81c\ucd9c \uc131\uacf5 \uba54\uc2dc\uc9c0\ub97c \ubcf4\uace0, \uc791\uc5c5 \uc9c4\ud589\uc744 \ubcf4\uae30 \uc704\ud574 \uc791\uc5c5 \ubcf4\uae30\ub97c \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 12> \uc791\uc5c5\uc774 \uc2e4\ud589 \uc911\uc774\ub77c\ub294 \ud654\uba74\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \ud38c\ud504 \uc791\uc5c5 \ubaa8\ub2c8\ud130\ub97c \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 13> \uc791\uc5c5\uc758 \uc77c\uc2dc \uc815\uc9c0\ub97c \uc704\ud574 \uc791\uc5c5 \uc0c1\ud0dc \ubcc0\uacbd\uc744 \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 14> \uc77c\uc2dc \uc911\uc9c0\ub97c \uc120\ud0dd\ud55c\ub2e4. \uc815\uc9c0\ub97c \uc120\ud0dd\ud560 \uacbd\uc6b0 \ub2e4\uc2dc \uc2e4\ud589\ud560 \uc218 \uc5c6\uac8c \ub41c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 15> \uc791\uc5c5 \uc0c1\ud0dc \ubcc0\uacbd \uc131\uacf5\uc744 \ud655\uc778\ud55c \ud6c4 \ud655\uc778\uc744 \ub20c\ub7ec \ubcc0\uacbd \uc0ac\ud56d\uc744 \ud655\uc778\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 16> \uc0c1\ud0dc\uac00 \uc2e4\ud328\ud568\uc73c\ub85c \ubcf4\uc778\ub2e4. \uc774\ub294 \uc77c\uc2dc \uc815\uc9c0\ub97c \ub098\ud0c0\ub0b8\ub2e4. \uc7ac\uc2dc\ub3c4\ub97c \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 17> \uc7ac\uc2dc\ub3c4 \uc791\uc5c5\uc744 \uc704\ud574 \uc608\ub97c \ud074\ub9ad\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 18> \uacc4\uc18d \uc2e4\ud328 \ub41c \uc0c1\ud0dc\ub85c \ub098\uc628\ub2e4. \ub2e4\uc74c \uc2dc\ub3c4\ub97c \ud074\ub9ad\ud558\uba74 \ubcc0\ud654\ub41c \uac83\uc744 \ubcfc \uc218 \uc788\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 19> \ub610\ud55c \uc791\uc5c5 \ubaa8\ub2c8\ud130\ub9c1\uc744 \ubcf4\uc544\ub3c4 executing\uc784\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 20> \uc0c1\ud0dc\uac00 \uc131\uacf5\ud568 \uc774\uba74 \uc2e4\uc81c \ub85c\uadf8\ub97c \ubcf4\uc544 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc131\uacf5\ud568\uc744 \ud655\uc778\ud558\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 21> \uc774 \ub0b4\uc6a9\uc740 \uc2e4\uc81c OS\uc5d0 \ub9cc\ub4e4\uc5b4\uc9c4 log\uc640 \uac19\uc740 \ub0b4\uc6a9\uc774\ub2e4.\n<\/p>\n

                \n <\/p>\n

                \n

                IMPDP TEST
                \n<\/h2>\n<\/p>\n

                Test \ubc29\uc2dd\uc740 expdp\uc640 \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \ud55c\ub2e4\n<\/p>\n

                \n

                \ud14c\uc2a4\ud2b82-1 Text Mode\ub97c \ud1b5\ud55c impdp \ud14c\uc2a4\ud2b8
                \n<\/h3>\n<\/p>\n

                expdp\ub85c \ubc1b\uc740 dump file\uc744 \ud1b5\ud574 impdp\ub97c \uc2e4\ud589\ud574 \ubcf8\ub2e4. Impdp\ub97c \uc2e4\ud589\ud558\uae30 \uc804\uc5d0 scott user\uc758 \uac1d\uccb4\ub4e4\uc744 \uae68\ub057\uc774 \uc815\ub9ac\ud55c \ud6c4 impdp\ub97c \uc2e4\ud589\ud55c\ub2e4. \uc2e4\ud589\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc744 \ubcf4\uc5ec\uc900\ub2e4.\n<\/p>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                C:\\Download> impdp system\/manager directory=data_pump_dir dumpfile=expdat01.dmp logfile=data_pump_dir:imp.log<\/span>
                \n\t\t\t\t\t\t\t<\/span><\/p>\n

                \n <\/p>\n

                Import: Release 10.1.0.1.0 – Beta on <\/span>\uae08\uc694\uc77c<\/span>, 05 12<\/span>\uc6d4<\/span>, 2003 18:10
                \n<\/span><\/span><\/p>\n

                \n <\/p>\n

                Copyright (c) 2003, Oracle. All rights reserved.
                \n<\/span><\/p>\n

                \n <\/p>\n

                Connected to: Oracle10i Enterprise Edition Release 10.1.0.1.0 – Beta
                \n<\/span><\/p>\n

                With the Partitioning, OLAP and Data Mining options
                \n<\/span><\/p>\n

                \ub9c8\uc2a4\ud130<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ud14c\uc774\ube14<\/span> “SYSTEM”.”SYS_IMPORT_FULL_01″<\/span>\uc774<\/span>(<\/span>\uac00<\/span>) <\/span>\uc131\uacf5\uc801\uc73c\ub85c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ub85c\ub4dc\ub428<\/span>\/<\/span>\ub85c\ub4dc<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ucde8\uc18c\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                “SYSTEM”.”SYS_IMPORT_FULL_01″ <\/span>\uc2dc\uc791<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>: system\/******** directory=data_pump_dir d
                \n<\/span><\/span><\/p>\n

                umpfile=expdat01.dmp logfile=data_pump_dir:imp.log
                \n<\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/USER <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                ORA-31684: <\/span>\uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> USER:”SCOTT”: <\/span>\uc774<\/span>(<\/span>\uac00<\/span>) <\/span>\uc874\uc7ac\ud569\ub2c8\ub2e4<\/span>.
                \n<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/SYSTEM_GRANT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/ROLE_GRANT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/DEFAULT_ROLE <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/SE_PRE_SCHEMA_PROCOBJACT\/PROCACT_SCHEMA <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/TABLE <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/TABLE_DATA <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”TEST1″ 133.5 MB 500000<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc784\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”BONUS” 0 KB 0<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc784\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”DEPT” 3.656 KB 4<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc784\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”EMP” 5.820 KB 14<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc784\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”SALGRADE” 3.585 KB 5<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc784\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                . . “SCOTT”.”TEST” 0 KB 0<\/span>\ud589\uc774<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc784\ud3ec\ud2b8\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                \uac1d\uccb4<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc720\ud615<\/span> SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT <\/span>\ucc98\ub9ac<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc911<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

                “SYSTEM”.”SYS_IMPORT_FULL_01″ <\/span>\uc791\uc5c5\uc774<\/span> 1 <\/span>\uc624\ub958\uc640<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\ud568\uaed8<\/span> 18:11<\/span>\uc5d0\uc11c<\/span>
                \n\t\t\t\t\t\t\t\t<\/span>\uc644\ub8cc\ub428<\/span>
                \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                \n <\/p>\n

                \n <\/p>\n

                \n

                \ud14c\uc2a4\ud2b82-2 Enterprise Manager\ub97c \ud1b5\ud55c impdp \ud14c\uc2a4\ud2b8
                \n<\/h3>\n<\/p>\n

                \n <\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 20> expdp\uc640 \uac19\uc740 \uacbd\ub85c\ub97c \uac70\uccd0 maintenance \ud654\uba74\uc73c\ub85c \uc628\ub2e4. Import\ub97c \ud074\ub9ad\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 21> OS user\ub97c \uc368 \ub123\uc740 \ub2e4\uc74c, \uc2a4\ud0a4\ub9c8\ub97c \ud074\ub9ad\ud574\ubcf4\uc790\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 22> impdp\ub97c \uc2e4\ud589\ud560 scott user\uc640 users tablespace\ub97c \uc120\ud0dd\ud55c\ub2e4.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 23> \uadf8\ub9bc\uacfc \uac19\uc774 \uc120\ud0dd\ud558\uc600\ub2e4\uba74, \ub2e4\uc74c\uc744 \ud074\ub9ad\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 24> \ub85c\uadf8 \ud30c\uc77c \uc0dd\uc131\uc744 \uc120\ud0dd\ud55c \ud6c4 \ub2e4\uc74c\uc744 \ud074\ub9ad\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 25> \uc791\uc5c5 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc368\ub123\uc740 \ub2e4\uc74c \uc791\uc5c5\uc744 \uc989\uc2dc \uc2dc\uc791\uc73c\ub85c \uc120\ud0dd\ud558\uc5ec, \ub2e4\uc74c\uc744 \ud074\ub9ad\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 26> \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc791\uc5c5\uc744 \uac80\ud1a0\ud55c \ud6c4 \uc791\uc5c5 \uc81c\ucd9c\uc744 \ud074\ub9ad\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 27> \uc791\uc5c5\uc774 \uc131\uacf5\uc801\uc73c\ub85c \uc81c\ucd9c\ub428\uc744 \ud655\uc778\ud55c \ud6c4, \uc791\uc5c5 \ubcf4\uae30\ub97c \ud074\ub9ad\ud574 \ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 28> \ud604\uc7ac \uc791\uc5c5\uc774 \uc2e4\ud589\ub418\uace0 \uc788\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \ub85c\uadf8\ub97c \uc0b4\ud3b4\ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 29> \ub2e4\uc74c\uacfc \uac19\uc774 \uc218\ud589\ub418\uace0 \uc788\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \ucd94\uac00 \uc815\ubcf4 \ud45c\uc2dc\ub97c \ud074\ub9ad\ud574\ubcf4\uc790.\n<\/p>\n

                \n\t<\/p>\n

                <\uadf8\ub9bc 30> \ucd5c\uc885 \ub85c\uadf8\uac00 \ub2e4\uc74c\uacfc \uac19\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\n<\/p>\n

                \n

                \ud65c\uc6a9\uac00\uc774\ub4dc \ubc0f \uacb0\ub860
                \n<\/h2>\n<\/p>\n

                \uae30\uc874\uc758 exp & imp\uc5d0 \ube44\ud574 \ub354\uc6b1 \ud5a5\uc0c1\ub41c \uc131\ub2a5\uacfc \ubd88\ud544\uc694\ud55c parameter\ub294 \uc0ac\ub77c\uc9c0\uace0, \uae30\uc874\uc758 exp & imp\uc640\uc758 \ud638\ud658\uc744 \uc704\ud55c parameter\uac00 \uc788\uc5b4\uc11c Oracle 10g\uc758 data pump\ub97c \uc0ac\uc6a9\ud558\ub294 \ub370 \uc804\ud600 \ubb38\uc81c\uac00 \uc5c6\ub2e4. \ub530\ub77c\uc11c \uae30\uc874\uc758 exp & imp\ub97c \uc368\uc11c \ucc98\ub9ac\ud574\uc57c \ud588\ub358 \ubaa8\ub4e0 \uc5c5\ubb34\ub97c data pump\ub97c \uc0ac\uc6a9\ud558\uba74 \ub9e4\uc6b0 \ud6a8\uacfc\uc801\uc740 \uc5c5\ubb34 \ucc98\ub9ac\uac00 \ub420 \uc218 \uc788\uc744 \uac83\uc774\ub2e4.\n<\/p>\n

                \n <\/p>\n

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

                  Oracle 10g\uc758 new feature\uc778 Data Pump\ub294 Oracle Database data\uc640 metadata\uc758 \uc774\ub3d9\uc744 \uc704\ud55c \ub9e4\uc6b0 \ube60\ub978 infrastructure\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4. \ub530\ub77c\uc11c Oracle 9i\uae4c\uc9c0 \uc0ac\uc6a9\ub418\ub358 export, import utility\uc758 \ub354\uc6b1\ub354 \ud5a5\uc0c1\ub41c performance\ub97c \ubaa9\uc801\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc9c4 utility\uc774\ub2e4. \uae30\uc874\uc758 export, import\ub610\ud55c \uc9c0\uc6d0\ud558\ub294 Oracle 10g\uc758 \uc2e0\uae30\ub2a5\uc778 Data Pump\uc758 \ud2b9\uc9d5\uc744 \uc9c0\uae08\ubd80\ud130 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4. General Architecture \uc5ec\uae30\uc11c\ub294 \uac04\ub7b5\ud558\uac8c Data Pump\uac00 \uc5b4\ub5a4 \ubc29\uc2dd\uc73c\ub85c \ub3d9\uc791\ud558\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4. Direct Path […]<\/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":[10],"tags":[71,284,285,286,287],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/558"}],"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=558"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/558\/revisions"}],"predecessor-version":[{"id":4820,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/558\/revisions\/4820"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=558"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}