原因是IMPDP的时候 ,既写了tables=xxx 还写了 remap_schema=LIS:oai
报错的导入脚本:
IMPDP oai/oai@tempdb directory=EEE dumpfile=ENTRY_BDC.dmp logfile=ENTRY_BD_IMPDP.txt tables=TEMP_BDC_ENTRY,TEMP_BDC_LUJING remap_schema=LIS:oai remap_tablespace=LIS:oai
将 tables=TEMP_BDC_ENTRY,TEMP_BDC_LUJING 拿掉就好了:
修改后的:
IMPDP oai/oai@tempdb directory=EEE dumpfile=ENTRY_BDC.dmp logfile=ENTRY_BD_IMPDP.txt remap_schema=LIS:oai remap_tablespace=LIS:oai
-----------------------------------------------
就跟 expdp 同时写 了tables=xxx 和 schemas=LIS 一样,会报错