急,imp怪异问题,请高手协助
seani 2010-05-03 09:49:52 我原有系统平台是:window2003 32位+oracle9.0 32位版本,现exp导出dmp文件后,想倒入到linux 64位 oracle10。2.0.4 64位平台上,但倒了几次老提示以下错误。请高手协助,谢谢。
IMP-00041: 警告:创建的对象带有编译警告
"CREATE FORCE VIEW "ANYT"."DOMAIN_ADDRESS_VIEW" ("
""ADDRESS_ID","NAME","SIMPLE_CODE","PARENT_ADDR","CSTNAME") AS "
"SELECT ADDRESS_ID,DOMAIN_ADDRESS.NAME,SIMPLE_CODE,PARENT_ADDR ,CST_CUSTOMER"
".NAME"
" FROM DOMAIN_ADDRESS , CST_CUSTOMER WHERE CST_CUSTOMER.ADDR_ID = DOMAIN_"
"ADDRESS.ADDRESS_ID ORDER BY SIMPLE_CODE "
IMP-00017: 由于 ORACLE 错误 23308, 以下语句失败:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('ANYT', 'Tr_I_NOTIFY_SMS_"
"FINISHED_ID', FALSE); END;"
IMP-00003: 遇到 ORACLE 错误 23308
ORA-23308: 对象 ANYT.TR_I_NOTIFY_SMS_FINISHED_ID 不存在或无效
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: 在 "SYS.DBMS_DDL", line 335
ORA-06512: 在 line 1