expdp导出数据:
1、SELECT * FROM dba_directories;
2、CREATE OR REPLACE directory backup_path AS 'D:\app\Administrator\oradata\orcl';
3、grant read,write on directory backup_path to dangan;
4、expdp dangan/dangan@orcl schemas=dangan dumpfile=20181112.dmp DIRECTORY=backup_path
5、impdp dangan/dangan@orcl directory=backup_path dumpfile=20181226.DMP schemas=dangan
6、从schemas1导出,导入到schemas2报错,添加以下:
impdp dangan/dangan@orcl directory=backup_path dumpfile=20181226.DMP remap_schema= schemas1:schemas2