IMP/EXP正在将HR的对象导入到 HR

JServer Release 9.2.0.1.0 - Production

经由常规路径导出由EXPORT:V09.02.00创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将HR的对象导入到 HR
. . 正在导入表                   "DEPARTMENTS"         27行被导入
. . 正在导入表                     "EMPLOYEES"        107行被导入
准备启用约束条件...
成功终止导入，但出现警告。

C:\Documents and Settings\Administrator>imp hr/hr tables=employees,departments r
ows=y file=exp1.dmp

Import: Release 9.2.0.1.0 - Production on 星期五 12月 12 10:10:59 2008

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

连接到: Oracle9i Enterprise Edition 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创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将HR的对象导入到 HR
IMP-00015: 由于对象已存在，下列语句失败:
 "CREATE TABLE "DEPARTMENTS" ("DEPARTMENT_ID" NUMBER(4, 0), "DEPARTMENT_NAME""
 " VARCHAR2(30) CONSTRAINT "DEPT_NAME_NN" NOT NULL ENABLE, "MANAGER_ID" NUMBE"
 "R(6, 0), "LOCATION_ID" NUMBER(4, 0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXT"
 "RANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)              "
 "        LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在，下列语句失败:
 "CREATE TABLE "EMPLOYEES" ("EMPLOYEE_ID" NUMBER(6, 0), "FIRST_NAME" VARCHAR2"
 "(20), "LAST_NAME" VARCHAR2(25) CONSTRAINT "EMP_LAST_NAME_NN" NOT NULL ENABL"
 "E, "EMAIL" VARCHAR2(25) CONSTRAINT "EMP_EMAIL_NN" NOT NULL ENABLE, "PHONE_N"
 "UMBER" VARCHAR2(20), "HIRE_DATE" DATE CONSTRAINT "EMP_HIRE_DATE_NN" NOT NUL"
 "L ENABLE, "JOB_ID" VARCHAR2(10) CONSTRAINT "EMP_JOB_NN" NOT NULL ENABLE, "S"
 "ALARY" NUMBER(8, 2), "COMMISSION_PCT" NUMBER(2, 2), "MANAGER_ID" NUMBER(6, "
 "0), "DEPARTMENT_ID" NUMBER(4, 0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
 "S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)                 "
 "     LOGGING NOCOMPRESS"
成功终止导入，但出现警告。

C:\Documents and Settings\Administrator>