oracle的comment没生效,有comment字段的就不能导进去吗?

impdp有comment字段的就不能导进去吗?发现少了3张表

[oracle@localhost liang]$ impdp system/kingdee directory=impdir dumpfile=autodeploy.dmp schemas=autodeploy

Import: Release 10.2.0.1.0 - 64bit Production on Friday, 12 November, 2010 19:42:10

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** directory=impdir dumpfile=autodeploy.dmp schemas=autodeploy

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"AUTODEPLOY" already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39083: Object type TABLE failed to create with error:

ORA-00910: specified length too long for its datatype

Failing sql is:

CREATE TABLE "AUTODEPLOY"."T_DEPLOY_PLAN_FILE" ("FILE_ID" NUMBER(*,0) NOT NULL ENABLE, "PLAN_ID" NUMBER(*,0), "SUB_PLAN_ID" NUMBER(*,0), "MODULE_ID" NUMBER(*,0), "PRO_ID" NUMBER(*,0), "FILE_TYPE" NVARCHAR2(16), "DEPLOY_TYPE" NUMBER(*,0), "FILE_NAME" NVARCHAR2(256) DEFAULT '0', "FILE_PATH" NVARCHAR2(2048) DEFAULT '0') PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGIN

ORA-39083: Object type TABLE failed to create with error:

ORA-00910: specified length too long for its datatype

Failing sql is:

CREATE TABLE "AUTODEPLOY"."T_PLAN_EXEC_RECORD" ("RECORD_ID" NUMBER(*,0) NOT NULL ENABLE, "PLAN_ID" NUMBER(*,0), "SUB_PLAN_ID" NUMBER(*,0), "MODULE_ID" NUMBER(*,0), "NODE_SEQ_ID" NUMBER(*,0), "PRO_ID" NUMBER(*,0), "OPERATION_TYPE" NUMBER(*,0), "INPUT" NVARCHAR2(2048), "OUTPUT" NVARCHAR2(2048), "BEGIN_TIME" DATE, "END_TIME" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMP

ORA-39083: Object type TABLE failed to create with error:

ORA-00910: specified length too long for its datatype

Failing sql is:

CREATE TABLE "AUTODEPLOY"."T_PROJECT_INFO" ("PRO_ID" NUMBER(*,0) NOT NULL ENABLE, "MODULE_ID" NUMBER(*,0), "PRO_NAME" NVARCHAR2(128), "PRO_DES" NVARCHAR2(512), "PRO_TYPE" NUMBER(*,0), "PRO_BASE_DIR" NVARCHAR2(128), "CACHE_DIR" NVARCHAR2(128), "PRO_CFG_DIR" NVARCHAR2(2048)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTEN

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "AUTODEPLOY"."T_DEPLOY_PLAN"                9.203 KB       2 rows

. . imported "AUTODEPLOY"."T_DEPLOY_PLAN_ITEM"           7.296 KB       5 rows

. . imported "AUTODEPLOY"."T_HOST_INFO"                  8.023 KB       9 rows

. . imported "AUTODEPLOY"."T_MODULE_INFO"                9.625 KB      34 rows

. . imported "AUTODEPLOY"."T_MODULE_NODE_INFO"           6.851 KB      34 rows

. . imported "AUTODEPLOY"."T_PLAN_EXEC_STATUS"           8.945 KB       5 rows

. . imported "AUTODEPLOY"."T_SHELL_INFO"                 7.320 KB      26 rows

. . imported "AUTODEPLOY"."T_USER_INFO"                  6.648 KB       4 rows

. . imported "AUTODEPLOY"."T_OPERATION_SEQ"                  0 KB       0 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

ORA-39112: Dependent object type INDEX:"AUTODEPLOY"."PK_T_DEPLOY_PLAN_FILE" skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type INDEX:"AUTODEPLOY"."PK_T_PLAN_EXEC_RECORD" skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type INDEX:"AUTODEPLOY"."PK_T_PROJECT_INFO" skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

ORA-39112: Dependent object type CONSTRAINT:"AUTODEPLOY"."PK_T_DEPLOY_PLAN_FILE" skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type CONSTRAINT:"AUTODEPLOY"."PK_T_PLAN_EXEC_RECORD" skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type CONSTRAINT:"AUTODEPLOY"."PK_T_PROJECT_INFO" skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_DEPLOY_PLAN_FILE" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PLAN_EXEC_RECORD" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"AUTODEPLOY"."T_PROJECT_INFO" creation failed

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 36 error(s) at 19:42:18