背景
CC2.0V202001.00.000TGJSBZK.dmp是exp导出的,不是expdp导出。 当用命令
impdp hsliqpower/hsliqpower full=y directory='DATA_PUMP_DIR' dumpfile=CC2.0V202001.00.000TGJSBZK.dmp ignore=y REMAP_SCHEMA=hsliqpower:hsliqpower
导入的时候,报如下错误:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file "/orabak/expdp/CC2.0V202001.00.000TGJSBZK.dmp" may be an original export dump file
解决办法
imp hsliqpower/hsliqpower file=/data/oracle/app/oracle/orabak/expdp/CC2.0V202001.00.000TGJSBZK.dmp full=y ignore=n
###另外
- impdp有directory参数,imp没有directory参数
- oracle导入和导出要一致