Oracle数据泵,impdp,expdp,查看导出导入进度

最新推荐文章于 2024-09-23 16:48:57 发布

xzg1109

最新推荐文章于 2024-09-23 16:48:57 发布

阅读量1.5w

点赞数

分类专栏： Oracle 文章标签： oracle expdp impdp 数据泵

本文链接：https://blog.csdn.net/xzg1109/article/details/78942160

版权

Oracle 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

--获取JOB_NAME
select * from DBA_DATAPUMP_JOBS;

--使用attach参数
impdp sa/pwd attach=SYS_IMPORT_TABLE_01
expdp sa/pwd attach=SYS_EXPORT_TABLE_07

--例子
[oracle@xdcarch dump]$ impdp sa/pwd attach=SYS_IMPORT_TABLE_01
Import: Release 11.2.0.3.0 - Production on Sun Dec 31 16:03:34 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: SYS_IMPORT_TABLE_01
  Owner: SA                             
  Operation: IMPORT                         
  Creator Privs: FALSE                          
  GUID: 619EEBCA406748ECE053A002030A61F6
  Start Time: Sunday, 31 December, 2017 15:36:20
  Mode: TABLE                          
  Instance: ORAXDC
  Max Parallelism: 1
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        sa/******** DUMPFILE=BUSTB_TESTRESULT_201606.DMP DIRECTORY=DUMP_DIR LOGFILE=BUSTB_TESTRESULT_201606.LOG TABLES=BUSTB_TESTRESULT:RESULT_PART_201606 CONTENT=DATA_ONLY 
     INCLUDE_METADATA      0
  IMPORT Job Parameters:
     CLIENT_COMMAND        sa/******** dumpfile=BUSTB_TESTRESULT_201606.DMP directory=DUMP_DIR logfile=BUSTB_TESTRESULT_201606.log TABLES=BUSTB_TESTRESULT CONTENT=DATA_ONLY 
     INCLUDE_METADATA      0
  State: EXECUTING                      
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /u03/dump/BUSTB_TESTRESULT_201606.DMP
  
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: SA
  Object Name: BUSTB_TESTRESULT
  Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 1
  Completed Rows: 681,344,435
  Completed Bytes: 53,387,330,504
  Percent Done: 68
  Worker Parallelism: 1
Import> 

[oracle@xdcrac1 ~]$ expdp sa/pwd attach=SYS_EXPORT_TABLE_07
Export: Release 11.2.0.3.0 - Production on Sun Dec 31 15:58:53 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

Job: SYS_EXPORT_TABLE_07
  Owner: SA                             
  Operation: EXPORT                         
  Creator Privs: FALSE                          
  GUID: 619F1E2521ED4912E053DD5AA8C08866
  Start Time: Sunday, 31 December, 2017 15:50:25
  Mode: TABLE                          
  Instance: oraxdc1
  Max Parallelism: 1
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        sa/******** DUMPFILE=BUSTB_TESTRESULT_201607.DMP DIRECTORY=DUMP_DIR LOGFILE=BUSTB_TESTRESULT_201607.LOG TABLES=BUSTB_TESTRESULT:RESULT_PART_201607 CONTENT=DATA_ONLY 
     INCLUDE_METADATA      0
  State: EXECUTING                      
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /XDCBACKUP/database_full/BUSTB_TESTRESULT_201607.DMP
    bytes written: 4,096
  
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: SA
  Object Name: BUSTB_TESTRESULT
  Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 1
  Total Objects: 1
  Completed Rows: 879,649,029
  Worker Parallelism: 1

Export>

按 Ctrl+D 退出