导出的文件形如 tpam01.dmp,tpam02.dmp,tpam03.dmp,tpam04.dmp
导入步骤:
1、新建导入目录,如 E:\data_bak\dbbak
2、新建目录授权sql:grant_impdp_dir.sql,该例有五个用户需要授权,内容如下:
create or replace directory impdp_dir as 'E:\data_bak\dbbak'; grant read,write on directory impdp_dir to xir_app,xir_md,xir_trd,xir_trd_exh,xir_data; quit; |
cd D:\app\Administrator\product\11.2.0\dbhome_1\BIN sqlplus system/xpar@paxt @E:\data_bak\paxt\grant_impdp_dir.sql echo 正在导入系统数据库,请稍候... impdp system/xpar@paxt directory=impdp_dir dumpfile=tpam01.dmp,tpam02.dmp,tpam03.dmp,tpam04.dmp logfile=impdp_dir:xir_%DstDate%_in.log table_exists_action=skip exclude=statistics parallel=4 pause |