神_Azrael 神_Azrael
关注数: 11 粉丝数: 57 发帖数: 1,479 关注贴吧数: 8
求助啊。。。跪求。。 oracle如何导入不同用户的表? 我有一个表,以前的用户名是2006unitrust,数据库是9i 现在数据库换成了10G,创建2006unitrust失败,可能是由于起名规则的原因,于是改成了unitrust2006 现在的问题是表里有很多东西都因为用户名变了导不进来。。。请问应该如何操作? 我在网上查了一个,我用命令: imp unitrust2006/unitrust_db fromuser=2006unitrust touser=unitrust2006 file=/home/unitrustwebdb_20131115.dmp 但是还是不对。。。求助一下 错误信息如下: IMP-00017: following statement failed with ORACLE error 23308: "BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"2006UNITRUST"', '"ADMIN_ID_T" ""', FALSE); END;" IMP-00003: ORACLE error 23308 encountered ORA-23308: object 2006UNITRUST.ADMIN_ID_T does not exist or is invalid ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41 ORA-06512: at "SYS.DBMS_DDL", line 335 ORA-06512: at line 1 IMP-00041: Warning: object created with compilation warnings "CREATE TRIGGER "UNITRUST2006".PARTNER_SERVICE_ID_T before insert" "on PARTNER_SERVICE_T for each row" "" "" "" "declare" " integrity_error exception;" " errno integer;" " errmsg char(200);" " dummy integer;" " found boolean;" "" "begin" " -- Column "PARTNER_SERVICE_ID" uses sequence PARTNER_SERVICE_ID_S" " select PARTNER_SERVICE_ID_S.NEXTVAL INTO :new.PARTNER_SERVICE_ID from d" "ual;" "" "-- Errors handling" "exception" " when integrity_error then" " raise_application_error(errno, errmsg);" "end;" IMP-00017: following statement failed with ORACLE error 23308: "BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"2006UNITRUST"', '"PARTNER_SE" "RVICE_ID_T"', FALSE); END;" IMP-00003: ORACLE error 23308 encountered ORA-23308: object 2006UNITRUST.PARTNER_SERVICE_ID_T does not exist or is invalid ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41 ORA-06512: at "SYS.DBMS_DDL", line 335 ORA-06512: at line 1 IMP-00041: Warning: object created with compilation warnings "CREATE TRIGGER "UNITRUST2006".SUBJECT_ID_T before insert" "on USER_ACCOUNT_T for each row" "" "" "" "declare" " integrity_error exception;" " errno integer;" " errmsg char(200);" " dummy integer;" " found boolean;" "" "begin" " -- Column "SUBJECT_ID" uses sequence SUBJECT_ID_S" " select SUBJECT_ID_S.NEXTVAL INTO :new.SUBJECT_ID from dual;" "" "-- Errors handling" "exception" " when integrity_error then" " raise_application_error(errno, errmsg);" "end;" IMP-00017: following statement failed with ORACLE error 23308: "BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"2006UNITRUST"', '"SUBJECT_ID" "_T"', FALSE); END;" IMP-00003: ORACLE error 23308 encountered ORA-23308: object 2006UNITRUST.SUBJECT_ID_T does not exist or is invalid ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41 ORA-06512: at "SYS.DBMS_DDL", line 335 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 23308: "BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"2006UNITRUST"', '"TSA_ACCOUN" "T_ID_T"', FALSE); END;" IMP-00003: ORACLE error 23308 encountered ORA-23308: object 2006UNITRUST.TSA_ACCOUNT_ID_T does not exist or is invalid ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41 ORA-06512: at "SYS.DBMS_DDL", line 335 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 23308: "BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"2006UNITRUST"', '"USER_ID_T"" "', FALSE); END;" IMP-00003: ORACLE error 23308 encountered ORA-23308: object 2006UNITRUST.USER_ID_T does not exist or is invalid ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41 ORA-06512: at "SYS.DBMS_DDL", line 335 ORA-06512: at line 1 About to enable constraints... Import terminated successfully with warnings.
1 下一页