oracle导入dmp文件出错解决方法
oracle导入dmp文件出错
IMP-00017: 由于 ORACLE 错误 922, 以下语句失败:
"CREATE TABLE "BC_CMS_INFO" ("ID" VARCHAR2(32) NOT NULL ENABLE, "CHANNELID" "
"VARCHAR2(32), "INFOTYPE" NUMBER(*,0), "STATUS" NUMBER(*,0), "SECURITYID" VA"
"RCHAR2(32), "TITLE" VARCHAR2(200), "TITLECOLOR" VARCHAR2(50), "SUBTITLE" VA"
"RCHAR2(400), "INDEXTITLE" VARCHAR2(200), "INFO_LINK" VARCHAR2(200), "AUTHOR"
"" VARCHAR2(400), "SOURCEID" NUMBER(*,0), "WRITETIME" VARCHAR2(30), "KEYWORD"
"S" VARCHAR2(300), "SUMMARY" VARCHAR2(500), "DOCQUOTE" VARCHAR2(32), "INFOOR"
"DER" NUMBER(*,0), "INFOVALID" VARCHAR2(20), "CRTIME" VARCHAR2(20), "PUBTIME"
"" DATE, "CRUSER" VARCHAR2(50), "WORDCOUNT" NUMBER(*,0), "DOCVER" VARCHAR2(5"
"0), "CURVER" NUMBER(*,0), "COMMENT" NUMBER(*,0), "PUBLISHURL" VARCHAR2(500)"
", "BELONGID" VARCHAR2(32), "INFO_EXTEND" VARCHAR2(500), "INFO_COMMENT" NUMB"
"ER(*,0), "CONTENT" CLOB, "DOCID" VARCHAR2(32)) PCTFREE 10 PCTUSED 40 INITR"
"ANS 1 MAXTRANS 255 STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCO"
"MPRESS LOB ("CONTENT") STORE AS BASICFILE "BASICFILE" (TABLESPACE "USERS" "
"ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INI"
"TIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT))"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 选项缺失或无效（中间出现的无数 的导入的与语句）
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE TRIGGER "SZ_SCSJ".QUE_TRIG BEFORE"
"INSERT ON TB_QUEUE "
" FOR EACH ROW begin"
" select SEQ_QUE.nextval into :new.id from dual;"
"end;"
成功终止导入, 但出现警告。
------解决思路----------------------
跨版本做的数据迁移吧
用impdp/expdp 配合version参数，会比较好一些
------解决思路----------------------
假如你库是新建的，直接删掉，简单粗暴
IMP-00017: 由于 ORACLE 错误 922, 以下语句失败:
"CREATE TABLE "BC_CMS_INFO" ("ID" VARCHAR2(32) NOT NULL ENABLE, "CHANNELID" "
"VARCHAR2(32), "INFOTYPE" NUMBER(*,0), "STATUS" NUMBER(*,0), "SECURITYID" VA"
"RCHAR2(32), "TITLE" VARCHAR2(200), "TITLECOLOR" VARCHAR2(50), "SUBTITLE" VA"
"RCHAR2(400), "INDEXTITLE" VARCHAR2(200), "INFO_LINK" VARCHAR2(200), "AUTHOR"
"" VARCHAR2(400), "SOURCEID" NUMBER(*,0), "WRITETIME" VARCHAR2(30), "KEYWORD"
"S" VARCHAR2(300), "SUMMARY" VARCHAR2(500), "DOCQUOTE" VARCHAR2(32), "INFOOR"
"DER" NUMBER(*,0), "INFOVALID" VARCHAR2(20), "CRTIME" VARCHAR2(20), "PUBTIME"
"" DATE, "CRUSER" VARCHAR2(50), "WORDCOUNT" NUMBER(*,0), "DOCVER" VARCHAR2(5"
"0), "CURVER" NUMBER(*,0), "COMMENT" NUMBER(*,0), "PUBLISHURL" VARCHAR2(500)"
", "BELONGID" VARCHAR2(32), "INFO_EXTEND" VARCHAR2(500), "INFO_COMMENT" NUMB"
"ER(*,0), "CONTENT" CLOB, "DOCID" VARCHAR2(32)) PCTFREE 10 PCTUSED 40 INITR"
"ANS 1 MAXTRANS 255 STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCO"
"MPRESS LOB ("CONTENT") STORE AS BASICFILE "BASICFILE" (TABLESPACE "USERS" "
"ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INI"
"TIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT))"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 选项缺失或无效（中间出现的无数 的导入的与语句）
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE TRIGGER "SZ_SCSJ".QUE_TRIG BEFORE"
"INSERT ON TB_QUEUE "
" FOR EACH ROW begin"
" select SEQ_QUE.nextval into :new.id from dual;"
"end;"
成功终止导入, 但出现警告。
------解决思路----------------------
跨版本做的数据迁移吧
用impdp/expdp 配合version参数，会比较好一些
------解决思路----------------------
假如你库是新建的，直接删掉，简单粗暴