关于数据库导入问题

taoy_2008

imp操作在我机器上导入正常。但是在同事的机器上出错了。相同的数据库版本号。
唯一区别就是我是windows 32 ，同事的是windows 64.但是imp 可以跨操作系统，跟这个没关系。
但是在同事这边报错日志如下：
   
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by DSRIS, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing DSRIS's objects into APPS
. . importing partition        "INFECTIONCARD":"PART1"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'APPS.TRI_INFECTIONCARD_CDLOG' is invalid and failed re-validation
. . importing partition        "INFECTIONCARD":"PART2"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'APPS.TRI_INFECTIONCARD_CDLOG' is invalid and failed re-validation
. . importing partition        "INFECTIONCARD":"PART3"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'APPS.TRI_INFECTIONCARD_CDLOG' is invalid and failed re-validation
. . importing partition        "INFECTIONCARD":"PART4"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'APPS.TRI_INFECTIONCARD_CDLOG' is invalid and failed re-validation
. . importing partition        "INFECTIONCARD":"PART5"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'APPS.TRI_INFECTIONCARD_CDLOG' is invalid and failed re-validation
. . importing partition        "INFECTIONCARD":"PART6"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'APPS.TRI_INFECTIONCARD_CDLOG' is invalid and failed re-validation
. . importing partition        "INFECTIONCARD":"PART7"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'APPS.TRI_INFECTIONCARD_CDLOG' is invalid and failed re-validation
. . importing partition        "INFECTIONCARD":"PART8"
IMP-00058: ORACLE error 4098 encountered

Maclean Liu(刘相兵

[oracle@vrh8 ~]$ oerr ora 4098
04098, 00000, "trigger '%s.%s' is invalid and failed re-validation"
// *Cause: A trigger was attempted to be retrieved for execution and was
//         found to be invalid.  This also means that compilation/authorization
//         failed for the trigger.
// *Action: Options are to resolve the compilation/authorization errors,
//         disable the trigger, or drop the trigger.


ignore=y  =》说明你的对象结构都是已经存在的


建议你 recompile 整个失效的 trigger:

1.  alter trigger APPS.TRI_INFECTIONCARD_CDLOG compile

或者 disable 这个trigger
2.   alter trigger APPS.TRI_INFECTIONCARD_CDLOG  disable


之后再重试 imp导入

taoy_2008

imp apps/apps file=E:\imp\cmcd.dmp fromuser=apps touser=apps log=E:\imp\cmcd..log buffer=1024000  ignore=y

Maclean Liu(刘相兵

至少把你的 imp 语句贴出来吧