30 10 2018
Oracle impdp
일부 테이블만 의 경우
먼저 Directory Dump를 만든다.
|
1 2 3 4 5 6 7 |
SQL> CREATE DIRECTORY KWCYBERDUMP AS '/./../kwcyber'; Directory created. SQL> GRANT read,write on directory KWCYBERDUMP to 오라클계정; Grant succeeded. |
|
1 |
oracle$]impdp 오라클계정/패스워드@SID directory=KWCYBERDUMP dumpfile=file.dmp tables=tu_progress_log table_exists_action=append; |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
Import: Release 11.2.0.1.0 - Production on Tue Oct 30 17:57:25 2018 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "계정"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "계정"."SYS_IMPORT_TABLE_01": 계정/********@SID directory=KWCYBERDUMP dumpfile=file.dmp tables=tu_progress_log table_exists_action=append Processing object type SCHEMA_EXPORT/TABLE/TABLE ORA-39152: Table "계정"."TU_PROGRESS_LOG" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "계정"."TU_PROGRESS_LOG" 541.8 MB 5260803 rows Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "계정"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 17:59:32 |