oracle导入dmp文件出错

[宁i]

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;"
成功终止导入, 但出现警告。

[宁i]

引用 楼主 cwj1103 的回复:

这是我导入执行的语句。imp SZ_SCSJ/SZ_SCSJ@ORCL full=y file=E:\scsj\scsj.dmp ignore=y 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;" 成功终止导入, 但出现警告。

[一颗向往数据的心丶]

假如你库是新建的，直接删掉，简单粗暴

[小灰狼W]

跨版本做的数据迁移吧 用impdp/expdp 配合version参数，会比较好一些

[宁i]

引用 2 楼 wildwave 的回复:

跨版本做的数据迁移吧 用impdp/expdp 配合version参数，会比较好一些

我现在已经导入了，该怎么先把里面的数据删除呢？ 然后重新导入。语句是什么？可以写一下吗？