将数据从运行数据库(操作系统为NT)导出来,然后导入备份服务器(操作系统为win2000 Server)时,出现的问题,每次导入总是少一个表。而其他表导入正常。错误提示为IMP-00017: following statement failed with ORACLE error 604:
然后是一个Create Table 语句。IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 942:
"ALTER TABLE "VOIPCDR" ENABLE CONSTRAINT "VOIPCDR_PKDATEREGIPTIMELINE""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
Import terminated successfully with warnings.
然后是一个Create Table 语句。IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 942:
"ALTER TABLE "VOIPCDR" ENABLE CONSTRAINT "VOIPCDR_PKDATEREGIPTIMELINE""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
Import terminated successfully with warnings.
exp80 system/manager buffer=40000000 owner= user1 file=d:\EXPdat.dmp
导入语句为
imp80 system/manager buffer=40000000 fromuser = user1 touser = user1 file=d:\EXPdat.dmp
不要用命令模式,这样你就可以选择很多参数,可以琢磨一下什么地方出错了cmd
c:/>exp
就可
有时候是由于这个表要分配空间大于系统的限制了,你用原始脚本CREATE
再IMP 时 加上 IGNORE=Y忽略错误,就可以把数据,约束,之类的导进去了。