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