oracle ignore =y,imp一个表的时候为什么不加IGNORE=y就不成功呢?

这个表是存在的,只是没有数据.结构都在.

ILDMCEDM01% imp EDMADMIN/EDMADMIN buffer=4096 file=/DMCDBS01/oracle/expdat.dmp TABLES=CD_POLICY_SOURCE

Import: Release 9.2.0.1.0 - Production on Sat Oct 27 19:20:01 2007

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

Connected to: 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 file created by EXPORT:V09.02.00 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses WE8ISO8859P1 character set (possible charset conversion)

. importing EDMADMIN's objects into EDMADMIN

IMP-00015: following statement failed because the object already exists:

"CREATE TABLE "CD_POLICY_SOURCE" ("CUSTOMER_NAME" NVARCHAR2(60), "POLICY_ID""

" CHAR(10) NOT NULL ENABLE, "ATTACHMENT_JOURNAL_ID" CHAR(5), "ERROR_SURFACE""

" NUMBER(5, 0), "CUSTOMER_DIVISION" NVARCHAR2(50), "CUSTOMER_REPRESENTATIVE""

" NVARCHAR2(60), "WALK_TYPE" NUMBER(5, 0), "CUSTOMER_GROUP" NVARCHAR2(50), ""

"CUSTOMER_ADDRESS" NVARCHAR2(255), "ERROR_MODEL" NUMBER(5, 0), "CUSTOMER_TEL"

"EPHONE" NVARCHAR2(50), "SCAN_METHOD" NUMBER(5, 0), "WARNING_METHOD" NUMBER("

"5, 0), "ERROR_OUTPUT_LEVEL" FLOAT(126), "SURVEY_CALC" NUMBER(5, 0), "VS_ORI"

"GIN" NUMBER(5, 0), "IS_READONLY" NVARCHAR2(1), "REPORTING_STANDARD" NUMBER("

"5, 0), "REPORTING_TIME" DATE, "PASSWORD_1" NVARCHAR2(8), "PASSWORD_2" NVARC"

"HAR2(8), "ERROR_LEVEL" FLOAT(126), "USE_CASING" NUMBER(5, 0), "CREATE_DATE""

" DATE, "CREATE_USER_ID" NVARCHAR2(30), "CREATE_APP_ID" NVARCHAR2(20), "UPDA"

"TE_DATE" DATE, "UPDATE_USER_ID" NVARCHAR2(30), "UPDATE_APP_ID" NVARCHAR2(20"

&quot

, "REMARKS" NVARCHAR2(2000), "P_LOCK_PASSWORD" NVARCHAR2(10), "P_LOCK_USER"

"_NAME" NVARCHAR2(30), "P_VIEW_SORT" NUMBER(*,0) NOT NULL ENABLE, "TIGHT_GRO"

"UP_ID" CHAR(5))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INIT"

"IAL 16384 FREELISTS 1 FREELIST GROUPS 1)                    LOGGING NOCOMPR"

"ESS"

Import terminated successfully with warnings.

JILDMCEDM01% imp EDMADMIN/EDMADMIN buffer=4096 IGNORE=y file=/DMCDBS01/oracle/expdat.dmp TABLES=CD_POLICY_SOURCE

Import: Release 9.2.0.1.0 - Production on Sat Oct 27 19:21:22 2007

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

Connected to: 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 file created by EXPORT:V09.02.00 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses WE8ISO8859P1 character set (possible charset conversion)

. importing EDMADMIN's objects into EDMADMIN

. . importing table             "CD_POLICY_SOURCE"         12 rows imported

Import terminated successfully without warnings.