1.创建导出的路径
create directory dump_dir as '/u01/expdb'
2.登陆数据库服务器
导出数据:
expdb core1/core1 directory =dump_dir dump file=20141105.dmp logfile=exp_core1_'date+%Y%m%d'.log
导入数据:
nohup impdb core3/core3 directory=dump_dir dumpfile=20141105.dmp logfile=imp_core3_'date+%Y%m%d'.log remap_schema=core1/core3 remap_tablespace=core_tbs01:core_tbs03 TRANSFORM=OID:n&