实在搞不清原因了
log如下：
Import started on 2007-9-28 下午 01:29:31
F:\oracle10g\bin\imp.exe log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=G:\2007-08-08.dmp userid=upp/upp@ORA buffer=30720 commit=yes full=yes grants=yes ignore=no indexes=yes rows=yes show=yes constraints=yes
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
经由直接路径由 EXPORT:V10.02.01 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 UPP 的对象导入到 UPP
. 正在将 UPP 的对象导入到 UPP
"CREATE TABLE "ACCOUNT" ("ID" NUMBER NOT NULL ENABLE, "ACCOUNT" VARCHAR2(50)"
", "PASSWORD" VARCHAR2(50), "ACCOUNT_LEVEL" VARCHAR2(50), "CATE" VARCHAR2(50"
"
, "DATE_TIME" DATE, "PHONE" VARCHAR2(50), "LINKPERSON" VARCHAR2(50), "MOBE"
"LPHONE" VARCHAR2(50), "TRUENAME" VARCHAR2(50))PCTFREE 10 PCTUSED 40 INITR"
"ANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFF"
"ER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . 正在跳过表 "ACCOUNT"
"CREATE TABLE "ADMINISTRATION_PUNISHMENT_ITEM" ("ID" NUMBER NOT NULL ENABLE,"
" "YEAR" VARCHAR2(4000), "TYPE" VARCHAR2(4000), "F_NUMBER" VARCHAR2(4000), ""
"TRANSGRESS_BUILD_ITEM_NAME" VARCHAR2(4000), "TRANSGRESS_BUILD_COMPANY" VARC"
"HAR2(4000), "TRANSGRESS_BUILD_ADDR" VARCHAR2(4000), "BUILD_USE_GROUND_PERMI"
"SSION_ID" VARCHAR2(4000), "BUILD_PERMISSION_AREA" VARCHAR2(4000), "BUILD_US"
"E_PERSON" VARCHAR2(4000), "BUILD_PROJECT_PERMISSION_ID" VARCHAR2(4000), "BU"
"ILD_PROJECT_PERMISSION_AREA" VARCHAR2(4000), "BUILD_PERMISSION_PERSON" VARC"
"HAR2(4000), "TRANSGRESS_USE_GROUND_AREA" VARCHAR2(4000), "TRANSGRESS_BUILD_"
"AREA" VARCHAR2(4000), "ADMIN_PUNISHMENT_DECISION" VARCHAR2(4000), "ADMIN_PU"
"NISHMENT_PERSON" VARCHAR2(4000), "ADMINISTRATION_PUNISHMENT_INFO" VARCHAR2("
"4000), "EXECUTE_PERSON" VARCHAR2(4000), "PAGE" VARCHAR2(4000), "SECRET_LEVE"
"L" VARCHAR2(4000), "SAVE_TERM" VARCHAR2(4000), "REMARK" VARCHAR2(4000), "AD"
"DPERSON" VARCHAR2(4000), "ADDTIME" DATE)PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 524288 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO"
"OL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
" ALTER TABLE "ADMINISTRATION_PUNISHMENT_ITEM" MODIFY ("ADDTIME" DEFAULT sys"
"date"
"
"
. . 正在跳过表 "ADMINISTRATION_PUNISHMENT_ITEM"
"CREATE TABLE "ADMINPUNISHII" ("ADMIN_PUNISH_ID" NUMBER NOT NULL ENABLE, "CA"
"SEINDEX" VARCHAR2(4000), "CASESOURCE" VARCHAR2(4000), "CASECODE" VARCHAR2(4"
"000), "CONSTRUCTDEPT" VARCHAR2(4000), "BUILDPROJNAME" VARCHAR2(4000), "PROJ"
"LOCATION" VARCHAR2(4000), "PROJPROPERTY" VARCHAR2(4000), "AREALICENCCODE" V"
"ARCHAR2(4000), "LANDAREA" VARCHAR2(4000), "PLANLICENCCODE" VARCHAR2(4000), "
""BUILDAREA" VARCHAR2(4000), "PROJSTARTCODE" VARCHAR2(4000), "STARTTIME" VAR"
"CHAR2(4000), "VOILATIONPROPERTY" VARCHAR2(4000), "VOILATIONFACT" VARCHAR2(4"
"000), "DISCOVERYTIME" VARCHAR2(4000), "PROGRESSANDAREA" VARCHAR2(4000), "DE"
"ALPERSON" VARCHAR2(4000), "CASETIME" VARCHAR2(4000), "EVIDENCE" VARCHAR2(40"
"00), "MEETINGBRIEFCODE" VARCHAR2(4000), "PUNISHDEALTIME" VARCHAR2(4000), "P"
"UNISHMENTCONTENT" VARCHAR2(4000), "RIGHTTOLDTIME" VARCHAR2(4000), "IFAPPAUD"
"ITION" VARCHAR2(4000), "AUDRESULT" VARCHAR2(4000), "REDEALSUIT" VARCHAR2(40"
"00), "REDEALSUITRESULT" VARCHAR2(4000), "PUNISHDISCODE" VARCHAR2(4000), "PU"
"NISHCONTENT" VARCHAR2(4000), "PUNISHAMOUNT" VARCHAR2(4000), "PUNISHDESTRUCT"
"AREA" VARCHAR2(4000), "DISPAPERTIME" VARCHAR2(4000), "PUNISHARRTIME" VARCHA"
"R2(4000), "IFRESTORED" VARCHAR2(4000), "LATESTEXETIME" VARCHAR2(4000), "EXE"
"CUTIONMETHOD" VARCHAR2(4000), "RECPUNISHAMOUNT" VARCHAR2(4000), "MONEYWITHS"
"TUFF" VARCHAR2(4000), "STUFFAUDAMOUNT" VARCHAR2(4000), "EXEDISTRUCTAREA" VA"
"RCHAR2(4000), "IFCASEFINISH" VARCHAR2(4000), "CASEFINISHTIME" VARCHAR2(4000"
"
, "FINISHDEALPERSON" VARCHAR2(4000), "FINISHCHECKCODE" VARCHAR2(4000), "AD"
"DPERSON" VARCHAR2(4000), "ADDTIME" DATE)PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO"
"OL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
" ALTER TABLE "ADMINPUNISHII" MODIFY ("ADDTIME" DEFAULT sysdate"
"
"
. . 正在跳过表 "ADMINPUNISHII"
"CREATE TABLE "BASE_ESTABLISHMENT_ITEM" ("ID" NUMBER NOT NULL ENABLE, "YEAR""
" VARCHAR2(4000), "TYPE" VARCHAR2(4000), "F_NUMBER" VARCHAR2(4000), "BUILD_P"
"RO_NAME" VARCHAR2(4000), "BUILD_COMPANY" VARCHAR2(4000), "BUILD_ADDR" VARCH"
"AR2(4000), "BASE_ESTABLISHMENT_PIC" VARCHAR2(4000), "BUILD_PROJECT_PERMISSI"
"ON_ID" VARCHAR2(4000), "BUILD_PROJECT_PERMISSION_AREA" VARCHAR2(4000), "BUI"
"LD_PROJECT_PERMISSION_PIC" VARCHAR2(4000), "BUILD_PERMISSION_PERSON" VARCHA"
"R2(4000), "BUILD_PERMISSION_DATE" DATE, "OTHER_FILE" VARCHAR2(4000), "PAGE""
" VARCHAR2(4000), "SECRET_LEVEL" VARCHAR2(4000), "SAVE_TERM" VARCHAR2(4000),"
" "REMARK" VARCHAR2(4000), "ADDPERSON" VARCHAR2(4000), "ADDTIME" DATE, "BUIL"
"D_PROJECT_SCOPE" VARCHAR2(4000))PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS"
" 255 STORAGE(INITIAL 262144 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
" ALTER TABLE "BASE_ESTABLISHMENT_ITEM" MODIFY ("ADDTIME" DEFAULT sysdate"
"
"
. . 正在跳过表 "BASE_ESTABLISHMENT_ITEM"
"CREATE TABLE "BUILD_PROJECT_ITEM" ("ID" NUMBER NOT NULL ENABLE, "YEAR" VARC"
"HAR2(4000), "TYPE" VARCHAR2(4000), "F_NUMBER" VARCHAR2(4000), "BUILD_PRO_NA"
"ME" VARCHAR2(4000), "BUILD_COMPANY" VARCHAR2(4000), "BUILD_ADDR" VARCHAR2(4"
"000), "BUILD_ITEM_SELETADDR_ID" VARCHAR2(4000), "BUILD_ITEM_SELETADDR_AREA""
" VARCHAR2(4000), "BUILD_ITEM_SELETADDR_SCOPE" VARCHAR2(4000), "BUILD_ITEM_S"
"ELETADDR_PERSON" VARCHAR2(4000), "BUILD_ITEM_SELETADDR_DATE" DATE, "BUILD_U"
"SESITE_LAYOUT_ID" VARCHAR2(4000), "BUILD_USESITE_LAYOUT_AREA" VARCHAR2(4000"
"
, "BUILD_USESITE_LAYOUT_TYPE" VARCHAR2(4000), "BUILD_USESITE_LAYOUT_PIC" V"
"ARCHAR2(4000), "BUILD_USESITE_LAYOUT_PERSON" VARCHAR2(4000), "BUILD_USESITE"
"_LAYOUT_DATE" DATE, "GROUND_PASS_FILE_ID" VARCHAR2(4000), "GROUND_PASS_FILE"
"_PIC" VARCHAR2(4000), "BUILD_PROJECT_LAYOUT_ID" VARCHAR2(4000), "BUILD_PROJ"
"ECT_LAYOUT_SCOPE" VARCHAR2(4000), "BUILD_PROJECT_LAYOUT_TYPE" VARCHAR2(4000"
"
, "BUILD_PROJECT_LAYOUT_PIC" VARCHAR2(4000), "PROJECT_PERMISSION_PERSON" V"
"ARCHAR2(4000), "BUILD_PROJECT_PERMISSION_DATE" DATE, "BREAK_SCOPE_PIC" VARC"
"HAR2(4000), "BUILD_START_DATE" DATE, "BUILD_START_PERSON" VARCHAR2(4000), ""
"COMPLETE_CHECK_DATE" DATE, "COMPLETE_CHECK_PERSON" VARCHAR2(4000), "OTHER_F"
"ILE" VARCHAR2(4000), "PAGE" VARCHAR2(4000), "SECRET_LEVEL" VARCHAR2(4000), "
""SAVE_TERM" VARCHAR2(4000), "REMARK" VARCHAR2(4000), "ADDPERSON" VARCHAR2(4"
"000), "ADDTIME" DATE)PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAG"
"E(INITIAL 3145728 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES"
"PACE "USERS" LOGGING NOCOMPRESS"
" ALTER TABLE "BUILD_PROJECT_ITEM" MODIFY ("ADDTIME" DEFAULT sysdate"
"
"
. . 正在跳过表 "BUILD_PROJECT_ITEM"
"CREATE TABLE "INDIVIDUAL_BUILD_HOUSE_ITEM" ("ID" NUMBER NOT NULL ENABLE, "Y"
"EAR" VARCHAR2(4000), "TYPE" VARCHAR2(4000), "F_NUMBER" VARCHAR2(4000), "BUI"
"LD_PRO_NAME" VARCHAR2(4000), "BUILD_COMPANY" VARCHAR2(4000), "BUILD_ADDR" V"
"ARCHAR2(4000), "BUILD_USESITE_LAYOUT_ID" VARCHAR2(4000), "USE_TERRA_AREA" V"
"ARCHAR2(4000), "USE_TERRA_APPROBATE_PERSON" VARCHAR2(4000), "USE_TERRA_APPR"
"OBATE_DATE" DATE, "GROUND_APPROBATE_FILE_ID" VARCHAR2(4000), "GROUND_APPROB"
"ATE_FILE_PIC" VARCHAR2(4000), "BUILD_PROJECT_ID" VARCHAR2(4000), "BUILD_PRO"
"JECT_AREA" VARCHAR2(4000), "BUILD_PROJECT_PERSON" VARCHAR2(4000), "BUILD_PR"
"OJECT_DATE" DATE, "OTHER_FILE" VARCHAR2(4000), "PAGE" VARCHAR2(4000), "SECR"
"ET_LEVEL" VARCHAR2(4000), "SAVE_TERM" VARCHAR2(4000), "REMARK" VARCHAR2(400"
"0), "ADDPERSON" VARCHAR2(4000), "ADDTIME" DATE)PCTFREE 10 PCTUSED 40 INIT"
"RANS 1 MAXTRANS 255 STORAGE(INITIAL 13631488 FREELISTS 1 FREELIST GROUPS 1 "
"BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
" ALTER TABLE "INDIVIDUAL_BUILD_HOUSE_ITEM" MODIFY ("ADDTIME" DEFAULT sysdat"
"e"
"
"
. . 正在跳过表 "INDIVIDUAL_BUILD_HOUSE_ITEM"
"CREATE TABLE "UPP_ADDRBUILD_ALLOW" ("ID" NUMBER NOT NULL ENABLE, "NUMBERS" "
"VARCHAR2(200), "COMPANY" VARCHAR2(200), "NAME" VARCHAR2(200), "ADDR" VARCHA"
"R2(200), "AREA" VARCHAR2(200), "DATE_TIME" DATE)PCTFREE 10 PCTUSED 40 INI"
"TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BU"
"FFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . 正在跳过表 "UPP_ADDRBUILD_ALLOW"
"CREATE TABLE "UPP_ADDRLOCAL_ALLOW" ("ID" NUMBER NOT NULL ENABLE, "NUMBERS" "
"VARCHAR2(500), "COMPANY" VARCHAR2(500), "NAME" VARCHAR2(500), "ADDR" VARCHA"
"R2(500), "AREA" VARCHAR2(500), "DATE_TIME" DATE)PCTFREE 10 PCTUSED 40 INI"
"TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BU"
"FFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . 正在跳过表 "UPP_ADDRLOCAL_ALLOW"
"CREATE TABLE "UPP_ADDR_BOOK" ("ID" NUMBER NOT NULL ENABLE, "NUMBERS" VARCHA"
"R2(500), "COMPANY" VARCHAR2(500), "NAME" VARCHAR2(500), "ADDR" VARCHAR2(500"
"
, "SCOPE" VARCHAR2(500), "AREA" VARCHAR2(500), "DATE_TIME" DATE)PCTFREE "
"10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FRE"
"ELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . 正在跳过表 "UPP_ADDR_BOOK"
"CREATE TABLE "UPP_BEFORE_BUILD_MSG" ("ID" NUMBER NOT NULL ENABLE, "COMPANY""
" VARCHAR2(500), "NAME" VARCHAR2(500), "ADDR" VARCHAR2(500), "CONTENT" VARCH"
"AR2(1000), "START_DATE_TIME" DATE, "END_DATE_TIME" DATE, "USERID" VARCHAR2("
"50))PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGIN"
"G NOCOMPRESS"
. . 正在跳过表 "UPP_BEFORE_BUILD_MSG"
"CREATE TABLE "UPP_BUILD_MSG" ("ID" NUMBER NOT NULL ENABLE, "NUMBERS" VARCHA"
"R2(500), "ADDR" VARCHAR2(500), "NAME" VARCHAR2(500), "COMPANY" VARCHAR2(500"
"), "TYPE" VARCHAR2(500), "CONTENT" VARCHAR2(1000), "DATE_TIME" DATE, "USERI"
"D" VARCHAR2(50))PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INI"
"TIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "U"
"SERS" LOGGING NOCOMPRESS"
. . 正在跳过表 "UPP_BUILD_MSG"
"CREATE TABLE "UPP_PROJECT_FILE" ("P_ID" NUMBER NOT NULL ENABLE, "P_YEAR" NU"
"MBER(18, 0), "P_TYPE" VARCHAR2(100), "P_NUMB" VARCHAR2(100), "P_NAME" VARCH"
"AR2(100), "P_CPY" VARCHAR2(100), "P_ARS" VARCHAR2(100), "B_ID" VARCHAR2(100"
"), "B_D_AREA" VARCHAR2(53), "B_AREA" VARCHAR2(100), "B_PERSON" VARCHAR2(100"
"), "B_DATE" DATE, "P_ARS_ID" VARCHAR2(100), "P_AREA" VARCHAR2(100), "P_ARS_"
"P" VARCHAR2(100), "D_DATE" DATE, "P_UPP_ID" VARCHAR2(100), "P_BLDR_AREA" VA"
"RCHAR2(100), "P_UPP_PERSON" VARCHAR2(100), "G_DATE" DATE, "P_PAGE" VARCHAR2"
"(100), "P_PS" VARCHAR2(100), "P_DATE" VARCHAR2(100), "P_REMARK" VARCHAR2(10"
"00), "P_PIC" VARCHAR2(200), "P_PIC1" VARCHAR2(200), "P_PIC2" VARCHAR2(200),"
" "USERID" VARCHAR2(50))PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES"
"PACE "USERS" LOGGING NOCOMPRESS"
. . 正在跳过表 "UPP_PROJECT_FILE"
成功终止导入, 没有出现警告。
Import finished on 2007-9-28 下午 01:29:34
|
