Oracle使用expdp和impdp导出数据库表数据

1.创建directory及授权（如果默认directory不生效）

命令：

CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS \’c:\\dpdump\’;

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO PROACT; #或者直接授权默认directory

注意：路径必须是数据库所在服务器的路径

2.expdp导出表

命令：

expdp proact/proact#123456$ directory=DATA_PUMP_DIR tables=item_cfg,node,dependency,param_cntl,monitor_analysis,groupmos dumpfile=bppmtbls_202510.dmp logfile=bppmtbls_202510.log

output(包括表约束、索引等)：

;;;
Export: Release 11.2.0.1.0 – Production on 星期四 10月 30 15:17:47 2025

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
启动 \”PROACT\”.\”SYS_EXPORT_TABLE_01\”: proact/******** directory=DATA_PUMP_DIR tables=item_cfg,node,dependency,param_cntl,monitor_analysis,groupmos dumpfile=bppmtbls_202510.dmp