oracle imp导入时出现skipping table(二)

2014-11-24 15:17:51 · 作者: · 浏览: 1
R2(64), "M"
"ONTHLY_STMT_DESC_FORMAT_EN" VARCHAR2(1024), "MONTHLY_STMT_TRANS_TYPE_TC" VA"
"RCHAR2(64), "MONTHLY_STMT_DESC_FORMAT_TC" VARCHAR2(1024), "DISPLAY_SEQ" NUM"
"BER(3, 0), "IN_ATI_ENTITLEMENT" CHAR(1) NOT NULL ENABLE, "IS_DISPLAY" CHAR("
"1) NOT NULL ENABLE, "DR_OR_CR_STK_QTY" CHAR(2), "DESC_SC" VARCHAR2(64), "DA"
"ILY_STMT_TRANS_TYPE_SC" VARCHAR2(64), "DAILY_STMT_DESC_FORMAT_SC" VARCHAR2("
"1024), "MONTHLY_STMT_TRANS_TYPE_SC" VARCHAR2(64), "MONTHLY_STMT_DESC_FORMAT"
"_SC" VARCHAR2(1024), "HAS_RECEIVING_BANK" CHAR(1), "SHORT_DESC" VARCHAR2(64"
"), "IS_ACCOUNTING_USE" CHAR(1), "IS_PER_ACC_TYPE" CHAR(1), "TYPE_GRP" VARCH"
"AR2(20), "DESC_ACCTING_STD" VARCHAR2(128), "SYN_GRP" CHAR(1)) PCTFREE 10 P"
"CTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 196608 FREELISTS 1 FREELI"
"ST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GOEX_USERS_TBL" LOGGING NOCOMP"
"RESS"
" ALTER TABLE "SYS_TRANS_TYPE_TBL" MODIFY ("IN_ATI_ENTITLEMENT" DEFAULT 'N' "
")"
" ALTER TABLE "SYS_TRANS_TYPE_TBL" MODIFY ("IS_DISPLAY" DEFAULT 'Y' )"
" ALTER TABLE "SYS_TRANS_TYPE_TBL" MODIFY ("HAS_RECEIVING_BANK" DEFAULT 'N')"
" ALTER TABLE "SYS_TRANS_TYPE_TBL" MODIFY ("IS_ACCOUNTING_USE" DEFAULT 'N')"
" ALTER TABLE "SYS_TRANS_TYPE_TBL" MODIFY ("IS_PER_ACC_TYPE" DEFAULT 'N')"
. . skipping table "SYS_TRANS_TYPE_TBL"
"GRANT SELECT ON "SYS_TRANS_TYPE_TBL" TO "GOEX_WEBUSER_ROLE""
"CREATE INDEX "IN_ATI_ENTITLEMENT_IDX" ON "SYS_TRANS_TYPE_TBL" ("IN_ATI_ENTI"
"TLEMENT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELI"
"STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GOEX_SYSTEM_IDX" L"
"OGGING"
"CREATE UNIQUE INDEX "PK_SYS_TRANS_TYPE_TBL" ON "SYS_TRANS_TYPE_TBL" ("TYPE_"
"CD" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1"
" FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GOEX_SYSTEM_IDX" LOGGIN"
"G"
"ALTER TABLE "SYS_TRANS_TYPE_TBL" ADD CONSTRAINT "PK_SYS_TRANS_TYPE_TBL" PR"
"IMARY KEY ("TYPE_CD") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAG"
"E(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPA"
"CE "GOEX_SYSTEM_IDX" LOGGING ENABLE "
"COMMENT ON TABLE "SYS_TRANS_TYPE_TBL" IS 'Store transaction type'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."TYPE_CD" IS 'Transaction type code"
"'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DESC_EN" IS 'Description in Eng'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DESC_TC" IS 'Description in TC'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."ACC_HIST_DESC_FORMAT_EN" IS 'A/C h"
"istory description format in Eng'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."ACC_HIST_TRANS_TYPE_EN" IS 'A/C hi"
"story transaction type in Eng'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_TRANS_TYPE_EN" IS 'Dail"
"y statement transaction type in Eng'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_DESC_FORMAT_EN" IS 'Dai"
"ly statement description format in Eng'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_TRANS_TYPE_TC" IS 'Dail"
"y statement transaction type in T.Chi'"
"COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_DESC_FORMAT_TC" IS