1.创建目录sql下运行 将dmp文件复制到该文件件下
create or replace directory dmpdir as’/home/kingdee/Documents/8.5dmp’;
2.给system用户授予目录上的读写权限
grant read,write on directory dmpdir to hongbo;
3.确保对/home/oraback的执行权限–root
chown -R oracle:oinstall /home/kingdee/Documents/8.5dmp
chmod -R 777 /home/kingdee/Documents/8.5dmp
4.创建表空间 ()
CREATE TABLESPACE EAS_D_HONGBO_STANDARD DATAFILE ‘/home/oraback/EAS_D_HONGBO_STANDARD.ora’ SIZE 2000M AUTOEXTEND ON NEXT 200M;
CREATE TABLESPACE EAS_D_HONGBO_INDEX DATAFILE ‘/home/oraback/EAS_D_HONGBO_INDEX.ora’ SIZE 2000M AUTOEXTEND ON NEXT 200M ;
CREATE TABLESPACE EAS_D_HONGBO_TEMP2 DATAFILE ‘/home/oraback/EAS_D_HONGBO_TEMP2.dbf’ SIZE 2000M AUTOEXTEND ON NEXT 200M ;
CREATE TEMPORARY TABLESPACE EAS_T_HONGBO_STANDARD TEMPFILE ‘/home/oraback/EAS_T_HONGBO_STANDARD.dbf’ SIZE 2000M AUTOEXTEND ON NEXT 200M;
5.恢复脚本 (EAS_D_NEWDB850BC_STANDARD这个是原帐套的表空间,NEWDB850BC 是帐套名)
方式一 :
impdp hongbo/ok directory=dmpdir dumpfile=NEWDB850BC.DMP table_exists_action=replace REMAP_SCHEMA=NEWDB850BC:hongbo remap_tablespace=EAS_D_NEWDB850BC_STANDARD:EAS_D_HONGBO_STANDARD,EAS_T_NEWDB850BC_TEMP:EAS_T_HONGBO_TEMP job_name=liu_impdp exclude=statistics LOGFILE=impdp180814.log
方式二:
impdp hongbo/ok remap_schema=NEWDB850BC:hongbo remap_tablespace=EAS_D_NEWDB850BC_STANDARD:EAS_D_HONGBO_STANDARD remap_tablespace=EAS_D_NEWDB850BC_INDEX:EAS_D_HONGBO_INDEX remap_tablespace=EAS_D_NEWDB850BC_TEMP2:EAS_D_HONGBO_TEMP2 remap_tablespace=EAS_T_NEWDB850BC_STANDARD:EAS_T_HONGBO_STANDARD directory=dmpdir dumpfile=NEWDB850BC.DMP logfile=EAS2019061323.log
!!!!!参考网址
https://club.kingdee.com/forum.php?mod=viewthread&tid=1392433&extra=&page=2#page