2021-07-06
imp导入报错,IMP-00010
导出命令:
tables=name.name_unusual
rows=y
indexes=n
grants=n
triggers=n
constraints=y
compress=n
consistent=n
statistics=none
buffer=1000000
recordlength=65535
feedback=50000
filesize=30g
file=/data/oracle/2020_01.dmp,
/data/oracle/2020_02.dmp,
/data/oracle/2020_03.dmp,
/data/oracle/2020_04.dmp,
/data/oracle/2020_05.dmp,
/data/oracle/2020_06.dmp,
/data/oracle/2020_07.dmp,
/data/oracle/2020_08.dmp,
/data/oracle/2020_09.dmp,
/data/oracle/2020_10.dmp,
/data/oracle/2020_11.dmp
log=/data/oracle/2020_tab.log
导入命令:
parfile文件:
USERID='/ as sysdba'
fromuser=NAME
touser=NAME
ignore=y
buffer=409600000
feedback=100000
file=/data/2020_01.dmp,
/data/2020_02.dmp,
/data/2020_03.dmp,
/data/2020_04.dmp,
/data/2020_05.dmp,
/data/2020_06.dmp,
/data/2020_07.dmp,
/data/2020_08.dmp
log=imp_20210706.log
tables=NAME_UNUSUAL
报错:
[oracle@ imp_20210706_cm]$ imp parfile=imp_20210706.par
Import: Release 11.2.0.4.0 - Production on Tue Jul 6 17:12:47 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
导入报错,求解。
导出时是分割了6个文件,文件都传到目标端导入,报错。
收藏
分享
5条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
