imp system/jd@orcl file=d:\dmp\ora.dmp full=y ignore=y log=c:\test3.logIMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_CONNECTION_SCRIPT" ADD CON
" ("SCRIPT_ID") REFERENCES "ML_SCRIPT" ("SC
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_QA_DELIVERY" ADD FOREIGN K
"POSITORY" ("MSGID") ON DELETE CASCADE ENAB
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_QA_REPOSITORY_PROPS" ADD C
"EY ("MSGID") REFERENCES "ML_QA_REPOSITORY"
"LE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_TABLE_SCRIPT" ADD CONSTRAI
"ERSION_ID") REFERENCES "ML_SCRIPT_VERSION"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_TABLE_SCRIPT" ADD CONSTRAI
"RIPT_ID") REFERENCES "ML_SCRIPT" ("SCRIPT_
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
. importing HYING's objects into HYING
. importing OUTLN's objects into OUTLN
. importing SYSTEM's objects into SYSTEM
. importing SYSMAN's objects into SYSMAN
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with O
"ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL = 2
"SQL_CODE_TYPE = 'INTERPRETED' PLSQL_DEBUG
"ALL'PLSQL_CCFLAGS = ''"
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully
一张表主键还没建好,就开始引用了--,问了下老师,他说看,能不能先导表不导关系,,试了很多次了,变了几次参数都不行。而且建表空间就40几个G,导起来很费时间。急求好的解决办法
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_CONNECTION_SCRIPT" ADD CON
" ("SCRIPT_ID") REFERENCES "ML_SCRIPT" ("SC
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_QA_DELIVERY" ADD FOREIGN K
"POSITORY" ("MSGID") ON DELETE CASCADE ENAB
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_QA_REPOSITORY_PROPS" ADD C
"EY ("MSGID") REFERENCES "ML_QA_REPOSITORY"
"LE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_TABLE_SCRIPT" ADD CONSTRAI
"ERSION_ID") REFERENCES "ML_SCRIPT_VERSION"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
IMP-00017: following statement failed with O
"ALTER TABLE "ML_TABLE_SCRIPT" ADD CONSTRAI
"RIPT_ID") REFERENCES "ML_SCRIPT" ("SCRIPT_
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key
. importing HYING's objects into HYING
. importing OUTLN's objects into OUTLN
. importing SYSTEM's objects into SYSTEM
. importing SYSMAN's objects into SYSMAN
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with O
"ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL = 2
"SQL_CODE_TYPE = 'INTERPRETED' PLSQL_DEBUG
"ALL'PLSQL_CCFLAGS = ''"
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully
一张表主键还没建好,就开始引用了--,问了下老师,他说看,能不能先导表不导关系,,试了很多次了,变了几次参数都不行。而且建表空间就40几个G,导起来很费时间。急求好的解决办法
imp 执行导入的用户@被导入目标网络服务名 file=要导入的文件全路径 tables=(对象名1,对象名2......)--(指定对象)
不知道能不能帮到你
不符合主外键约束, 楼主先检查下下面几张表,看下主外键约束,
ML_CONNECTION_SCRIPT
ML_QA_DELIVERY先导入主表, 再导入依存表,disable目标导入对象的主外键约束, 导入数据后, 再enable它们
ALTER TABLE "ML_CONNECTION_SCRIPT" ADD CON
" ("SCRIPT_ID") REFERENCES "ML_SCRIPT"
导致DMP文件修改ML_CONNECTION_SCRIPT主键出错
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
IMP-00008: unrecognized statement in the export file:
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CREATE EXTERNAL JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION"
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT MERGE ANY VIEW TO "SYS""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CHANGE NOTIFICATION TO "SYS""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CREATE EXTERNAL JOB TO "SYS""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"SYS.DBMS_FILE_GROUP.GRANT_SYSTEM_PRIVILEGE(privilege => SYS.DBMS_FILE_GROUP"
".MANAGE_FILE_GROUP, grantee => 'DBA', grant_option => TRUE);"
"SYS.DBMS_FILE_GROUP.GRANT_SYSTEM_PRIVILEGE(privilege => SYS.DBMS_FILE_GROUP"
".MANAGE_FILE_GROUP, grantee => 'SYS', grant_option => FALSE);"
"SYS.DBMS_FILE_GROUP.GRANT_SYSTEM_PRIVILEGE(privilege => SYS.DBMS_FILE_GROUP"
".MANAGE_ANY_FILE_GROUP, grantee => 'DBA', grant_option => TRUE);"
"SYS.DBMS_FILE_GROUP.GRANT_SYSTEM_PRIVILEGE(privilege => SYS.DBMS_FILE_GROUP"
".MANAGE_ANY_FILE_GROUP, grantee => 'SYS', grant_option => FALSE);"
加了constraints=n就这样