oracle倒入数据时出错,帮忙看看什么原因。
ppqq2 2003-08-30 05:22:25 C:\>d:\oracle\ora92\bin\IMP.EXE
Import: Release 9.2.0.1.0 - Production on 星期六 8月 30 16:59:45 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
导入文件: EXPDAT.DMP> F:\table\table.sql
输入插入缓冲区大小(最小为 8192 ) 30720>
经由直接路径导出由EXPORT:V09.02.00创建的导出文件
警告: 此对象由 COMPIERE 导出, 而不是当前用户
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
只列出导入文件的内容 (yes/no): no > yes
导入整个导出文件 (yes/no): no > yes
. 正在将COMPIERE的对象导入到 SYS
"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"
.....最后出现这句:
IMP-00009: 导出文件异常结束
成功终止导入,但出现警告。