数据无法倒入
ppqq2 2003-08-31 09:32:02 用的是这个命令
d:\oracle\ora92\bin\IMP.EXE fromuser=REFERENCE touser=compiere file=F:\COMPIE~1\data\Compiere.dmp
userid=compiere/compiere@SHEN as sysdba buffer=30720 commit=yes
grants=yes ignore=yes indexes=yes rows=yes show=yes
constraints=yes
log大致是这样的:
用户名:
连接到: Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
经由常规路径导出由EXPORT:V09.02.00创建的文件
警告: 此对象由 REFERENCE 导出, 而不是当前用户
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
导出客户机使用WE8MSWIN1252字符集 (可能的字符集转换)
. 正在将REFERENCE的对象导入到 COMPIERE
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'REFERENCE',
export_db_"
"name=>'DEV2.COMPIERE.ORG', inst_scn=>'13794588');"
"COMMIT; END;"
"CREATE SEQUENCE "AD_ERROR_SEQ" MINVALUE 1 MAXVALUE
999999999999999999999999"
"999 INCREMENT BY 1 START WITH 141 CACHE 20 NOORDER NOCYCLE"
"CREATE SEQUENCE "AD_PINSTANCE_SEQ" MINVALUE 1 MAXVALUE
99999999999999999999"
"9999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
"CREATE SEQUENCE "C_ALLOCATION_SEQ" MINVALUE 1 MAXVALUE
99999999999999999999"
"9999999 INCREMENT BY 1 START WITH 13210 CACHE 20 NOORDER NOCYCLE"
"CREATE SEQUENCE "DBA_ERRORLOG_SEQ" MINVALUE 1 MAXVALUE
99999999999999999999"
"9999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
"CREATE SEQUENCE "T_SPOOL_SEQ" MINVALUE 1 MAXVALUE
9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
"CREATE SEQUENCE "W_BASKET_SEQ" MINVALUE 1 MAXVALUE
999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
"CREATE TABLE "AD_ALERT" ("AD_ALERT_ID" NUMBER(10, 0) NOT NULL
ENABLE, "AD_C"
"LIENT_ID" NUMBER(10, 0) NOT NULL ENABLE, "AD_ORG_ID" NUMBER(10,
0) NOT NULL"
" ENABLE, "ISACTIVE" CHAR(1) NOT NULL ENABLE, "CREATED" DATE NOT
NULL ENABLE"
", "CREATEDBY" NUMBER(10, 0) NOT NULL ENABLE, "UPDATED" DATE NOT
NULL ENABLE"
", "UPDATEDBY" NUMBER(10, 0) NOT NULL ENABLE, "NAME" NVARCHAR2(60)
NOT NULL "
"ENABLE, "DESCRIPTION" NVARCHAR2(255), "HELP" NVARCHAR2
(2000), "ALERTSUBJECT"
"" NVARCHAR2(60) NOT NULL ENABLE, "ENFORCECLIENTSECURITY" CHAR(1)
NOT NULL E"
"NABLE, "ENFORCEROLESECURITY" CHAR(1) NOT NULL
ENABLE, "ALERTMESSAGE" NVARCH"
"AR2(2000) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255 S"
"TORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE "USERS" LOGG"
"ING NOCOMPRESS"
" ALTER TABLE "AD_ALERT" MODIFY ("ISACTIVE" DEFAULT 'Y' )"
" ALTER TABLE "AD_ALERT" MODIFY ("CREATED" DEFAULT SYSDATE )"
" ALTER TABLE "AD_ALERT" MODIFY ("UPDATED" DEFAULT SYSDATE )"
" ALTER TABLE "AD_ALERT" MODIFY ("ENFORCECLIENTSECURITY"
DEFAULT 'Y' )"
" ALTER TABLE "AD_ALERT" MODIFY ("ENFORCEROLESECURITY"
DEFAULT 'Y' )"
. . 正在跳过表 "AD_ALERT"
最后是
成功终止导入,但出现警告。