1.查询系统directories
select * from dba_directories
2.导出相应的表
expdp nciclcc_a0/snsoft directory=tt dumpfile=online.dmp tables=AVAR,AADMINGROUP,AADMINORG,AADMINROLE,
ACCESSLOG,ADEGREE,AGROUP,AGROUPLEVEL,AGROUPROLE,ALANGUAGE,AORG,AORGLEADER,AORGLEVEL,AORGROLE,
AORGTYPE,APOST,AREPELLENTROLE,AROLE,AROLEPRIVILEG,AUSER,AUSERGROUP,AUSERROLE,AUSERTYPE,
AVAR,AVARIABLES
3.导入相应的表
impdp nciclccd_e/nciclccd_e directory=tt remap_schema=nciclcc_a0:nciclccd_e dumpfile=online.dmp