先创建表
CREATE TABLE "INFOR_FB" ("INFOR_ID" NUMBER(16, 0), "NAME" VARCHAR2(200) NOT"
" NULL ENABLE, "CONTENT" LONG NOT NULL ENABLE, "MJ" NUMBER(1, 0) NOT NULL EN"
"ABLE, "BANK_ID" NUMBER(6, 0) NOT NULL ENABLE, "INFOR_CREATE_ID" NUMBER(10, "
"0) NOT NULL ENABLE, "INFOR_EDIT_ID" NUMBER(10, 0) NOT NULL ENABLE, "INFOR_E"
"DIT_AUDIT_ID" NUMBER(10, 0) NOT NULL ENABLE, "INFOR_EDIT_CHIEF_ID" NUMBER(1"
"0, 0) NOT NULL ENABLE, "IMAGE_ID" NUMBER(10, 0), "IMAGE_POSITION" NUMBER(1,"
" 0), "CREATE_TIME" DATE NOT NULL ENABLE, "PUBLISH_TIME" DATE, "TEMPLATE_ID""
" NUMBER(10, 0), "STATUS" CHAR(1) NOT NULL ENABLE, "INFOR_CLASS_ID" NUMBER(3"
", 0), "HOME_IMAGE" CHAR(1), "PX" NUMBER(3, 0), "EXTNAME" VARCHAR2(10), "STS"
"" CHAR(1))
导入时候加上ignore=y试试
CREATE TABLE "INFOR_FB" ("INFOR_ID" NUMBER(16, 0), "NAME" VARCHAR2(200) NOT"
" NULL ENABLE, "CONTENT" LONG NOT NULL ENABLE, "MJ" NUMBER(1, 0) NOT NULL EN"
"ABLE, "BANK_ID" NUMBER(6, 0) NOT NULL ENABLE, "INFOR_CREATE_ID" NUMBER(10, "
"0) NOT NULL ENABLE, "INFOR_EDIT_ID" NUMBER(10, 0) NOT NULL ENABLE, "INFOR_E"
"DIT_AUDIT_ID" NUMBER(10, 0) NOT NULL ENABLE, "INFOR_EDIT_CHIEF_ID" NUMBER(1"
"0, 0) NOT NULL ENABLE, "IMAGE_ID" NUMBER(10, 0), "IMAGE_POSITION" NUMBER(1,"
" 0), "CREATE_TIME" DATE NOT NULL ENABLE, "PUBLISH_TIME" DATE, "TEMPLATE_ID""
" NUMBER(10, 0), "STATUS" CHAR(1) NOT NULL ENABLE, "INFOR_CLASS_ID" NUMBER(3"
", 0), "HOME_IMAGE" CHAR(1), "PX" NUMBER(3, 0), "EXTNAME" VARCHAR2(10), "STS"
"" CHAR(1))
导入时候加上ignore=y试试
数据库重作了不能再导出了,导入前先创建表,在导入时有ignore=y参数,但还是上面错误。至于 initial 、next的参数从小到大进行调整试验,还是上面问题。
请高手赐教。