技术文章 - CS41188
在Windchill PDMLink 10.0中，使用oracle 11g 导入数据失败: "IMP-00017: following statement failed with ORACLE error 942: "CREATE TRIGGER "dbUser".cleanPagingdata_trigger" "AFTER DELETE ON pagingSession".
已修改: 21-Oct-2016
适用于
- Windchill PDMLink 10.0 to 10.2
说明
- 导入Oracle数据失败.
- 发生于Oracle 11g.
- 使用Windchill 10.0数据库备份恢复系统失败:
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "<dbuser>".cleanPagingdata_trigger"
"AFTER DELETE ON pagingSession"
"FOR EACH ROW"
"BEGIN"
"DELETE FROM pageResults"
"WHERE sessionId = :old.IDA2A2;"
"DELETE FROM ExtendedPageResults"
"WHERE sessionId = :old.IDA2A2;"
"END;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "<dbuser>".cleanupIBACtxvalForRef_Trigger"
"AFTER DELETE ON ReferenceValue"
"FOR EACH ROW"
"BEGIN"
"DELETE FROM StringValue"
"WHERE idA3A5 = :old.IDA2A2;"
"DELETE FROM FloatValue"
"WHERE idA3A5 = :old.IDA2A2;"
"DELETE FROM UnitValue"
"WHERE idA3A5 = :old.IDA2A2;"
"DELETE FROM TimestampValue"
"WHERE idA3A5 = :old.IDA2A2;"
"DELETE FROM RatioValue"
"WHERE idA3A5 = :old.IDA2A2;"
"DELETE FROM IntegerValue"
"WHERE idA3A5 = :old.IDA2A2;"
"DELETE FROM BooleanValue"
"WHERE idA3A5 = :old.IDA2A2;"
"DELETE FROM URLValue"
"WHERE idA3A5 = :old.IDA2A2;"
"END;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
- 使用exp命令可以成功导出
- 使用 imp命令
这是文章 41188 的 PDF 版本，可能已过期。最新版本 CS41188