1. 创建表空间
create tablespace commdb
datafile 'D:\databaseBackup\haidian.dbf'
size 21000m
autoextend on
next 500m;
2.查询expdp导出的文件目录
select * from dba_directories;
3.导出
expdp userName/password@shcemaName directory=data_pump_dir dumpfile=your_export_datafile.dmp logfile=your_export_datafile_log.log
4.导入
impdp dest_username/dest_password@ip:1521/dest_schema DIRECTORY=DATA_PUMP_DIR DUMPFILE=your_export_datafile.dmp REMAP_SCHEMA=OLD_SCHEMA:NEW_SCHEMA REMAP_TABLESPACE=OLD_TABLESPACE:NEW_TABLESPACE
SCHEMA默认是用户名,此处的NEW_SCHEMA=dest_username