数据无法倒入

[ppqq2]

用的是这个命令
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"

最后是
成功终止导入，但出现警告。

[ppqq2]

出现这句，说明这个表没倒入？

. . 正在跳过表 "AD_ALERT"

可什么原因呢？

[shuipipi]

检查一下数据库用户compiere下该建的各对象都建立起来了没？

“成功终止导入，但出现警告。”是无碍大局的信息提示。

[ppqq2]

现在就到一个表，也不行？
到底什么意思啊？


C:\>d:\oracle\ora92\bin\IMP.EXE log=d:\plsimp.log file=F:\COMPIE~1\data\Compiere
.dmp buffer=30720 commit=yes grants=yes indexes=yes rows=yes show=yes constraint
s=yes fromuser=REFERENCE touser=compiere tables=ad_alert

Import: Release 9.2.0.1.0 - Production on 星期日 8月 31 09:36:20 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

用户名: compiere@shen as sysdba
口令:

连接到: 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
"ALTER SESSION SET CURRENT_SCHEMA= "COMPIERE""
"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"

"CREATE UNIQUE INDEX "AD_ALERT_KEY" ON "AD_ALERT" ("AD_ALERT_ID" ) PCTFREE "
"10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
"S 1) TABLESPACE "INDX" LOGGING"
"ALTER TABLE "AD_ALERT" ADD CONSTRAINT "AD_ALERT_KEY" PRIMARY KEY ("AD_ALER"
"T_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "INDX" LOGGING ENABLE "
成功终止导入，但出现警告。

[ppqq2]

compiere下该建的对象？
有哪些？

[tolywang]

1. 检查字符集是否一致
2. 所导用户是否建立 , 权限是否一致 ,是不是建立在同一表空间(总之 , 一摸一阳是最好)
3. 导出用哪个用户 , 导入就得用那个用户
4. Oracle系统的版本是否一致(8i,9i? )
5. 倒入时有警告很正常
6. 不妨试一下交互式的导入 , 不要手动加入参数 .
........


真的不能导 , 就建立一个database link吧 , 建立之后用 :
create table ad_alert as
select * from as_alert@dblink_name ; 就可以将表结构和数据 , index 等都导过来了 .