error:Duplicate key BuildableArtifactImpl (file collection)

本文探讨了在使用Gradle进行多渠道编译时遇到的常见问题:当指定渠道名称为'main'时,会触发Duplicate key异常。文章详细解释了错误原因,并提供了简单有效的解决方案——更改渠道名称,避免使用'main'。
productFlavors {  //在这里添加你所有需要打包的渠道
    main{
        buildConfigField "boolean", "PRODUCT_DEMO", "false"
    }
    demo{
        buildConfigField "boolean", "PRODUCT_DEMO", "true"
    }
}

多渠道编译时,如果其中一个渠道是main的话,gradle会报异常error:Duplicate key BuildableArtifactImpl (file collection),解决办法就是更改渠道的名称,不能使用main。

java.lang.IllegalStateException: Failed to execute ApplicationRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759) at org.springframework.boot.SpringApplication.lambda$callRunners$2(SpringApplication.java:746) at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) at java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:498) at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:487) at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:241) at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:485) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:744) at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1300) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1289) at com.zte.vd.insight.config.BootstrapApp.main(BootstrapApp.java:30) Caused by: org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "software_dict_pkey" (seg1 149.168.43. Detail: Key (process_name, os_type)=(powerpnt.exe, 0) already exists. ### The error may exist in file [/home/dexcloud/vd-config/conf/mapping/SoftwareProcessApdb.xml] 如何捕获异常并打印日志 List<List<SoftwareProcess> > splitedList = LocalUtils.splitList(softwareProcesses, BATCH_SIZE); for(List<SoftwareProcess> subList : splitedList){ int count = softwareProcessApMapper.batchInsertSoftwareProcess(subList); log.info("---------->>>>>softwareDictMigrationFromPgToAp: Migrate {} data's from PG to AP", count); }
03-25
ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_ESCI_PK" ON "SYSMAN"."MGMT_ECM_SNAP_COMPONENT_INFO" ("SNAPSHOT_GUID", "COMPONENT_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."CON_UK" ON "SYSMAN"."MGMT_INV_CONTAINER" ("SNAPSHOT_GUID", "CONTAINER_LOCATION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."ENT_PK" ON "SYSMAN"."MGMT_INV_COMPONENT" ("NAME", "VERSION", "CONTAINER_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MDIV_PK" ON "SYSMAN"."MGMT_DELTA_ID_VALUES" ("DELTA_IDS_GUID", "NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."OSP_SNP_PK" ON "SYSMAN"."MGMT_HC_OS_PROPERTIES" ("SNAPSHOT_GUID", "TYPE", "NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."TABLE_SIZES_PRIMARY_KEY" ON "SYSMAN"."MGMT_TABLE_SIZES" ("COLLECTION_TIMESTAMP", "TABLE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."INDEX_SIZES_PRIMARY_KEY" ON "SYSMAN"."MGMT_INDEX_SIZES" ("COLLECTION_TIMESTAMP", "INDEX_NAME", "TABLE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_TARGET_PROPERTIES_PK" ON "SYSMAN"."MGMT_TARGET_PROPERTIES" ("TARGET_GUID", "PROPERTY_NAME", "PROPERTY_TYPE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_STRING_METRIC_HISTORY_PK" ON "SYSMAN"."MGMT_STRING_METRIC_HISTORY" ("TARGET_GUID", "METRIC_GUID", "KEY_VALUE", "COLLECTION_TIMESTAMP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 3 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_METRIC_ERRORS_PK" ON "SYSMAN"."MGMT_METRIC_ERRORS" ("TARGET_GUID", "METRIC_GUID", "COLL_NAME", "AGENT_GUID", "COLLECTION_TIMESTAMP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 4 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."PARAMETERS_PRIMARY_KEY" ON "SYSMAN"."MGMT_PARAMETERS" ("PARAMETER_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_ECM_SNAP_IDX" ON "SYSMAN"."MGMT_ECM_SNAPSHOT" ("SNAPSHOT_TYPE", "TARGET_NAME", "TARGET_TYPE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_ECM_SNAP_IDX2" ON "SYSMAN"."MGMT_ECM_SNAPSHOT" ("IS_CURRENT", "TARGET_TYPE", "SNAPSHOT_TYPE", "TARGET_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_SUMMARY_IDX" ON "SYSMAN"."MGMT_INV_SUMMARY" ("SNAPSHOT_GUID", "MAP_TARGET_TYPE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_INV_COM_CONT_IDX" ON "SYSMAN"."MGMT_INV_COMPONENT" ("CONTAINER_GUID", "NAME", "VERSION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_COMPONENT_IDX_1" ON "SYSMAN"."MGMT_INV_COMPONENT" ("CONTAINER_GUID", "COMPONENT_GUID", "NAME", "VERSION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_VERSIONED_PATCH_PIDX" ON "SYSMAN"."MGMT_INV_VERSIONED_PATCH" ("PATCHSET_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_DEP_ER_IDX" ON "SYSMAN"."MGMT_INV_DEPENDENCY_RULE" ("REFERENCER_GUID", "DEPENDEE_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DELTA_IDS_IDX" ON "SYSMAN"."MGMT_DELTA_IDS" ("COLLECTION_TYPE", "KEY_STRING") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_ENTRY_ROWGUID_IDX" ON "SYSMAN"."MGMT_DELTA_ENTRY" ("ROW_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_ENTRY_SHOULD_BE_UK" ON "SYSMAN"."MGMT_DELTA_ENTRY" ("DELTA_GUID", "ROW_GUID", "DELTA_TIME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_ENTRY_TIME_IDX" ON "SYSMAN"."MGMT_DELTA_ENTRY" ("DELTA_TIME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_SNAP_IDX2" ON "SYSMAN"."MGMT_DELTA_SNAP" ("SNAPSHOT_TYPE", "TARGET_TYPE", "NEW_LEFT_TARGET_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 3 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_CPU_DETAILS_IDX" ON "SYSMAN"."MGMT_HC_CPU_DETAILS" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_IOCARD_DETAILS_IDX" ON "SYSMAN"."MGMT_HC_IOCARD_DETAILS" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_NIC_DETAILS_IDX" ON "SYSMAN"."MGMT_HC_NIC_DETAILS" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_OS_COMPONENTS_IDX1" ON "SYSMAN"."MGMT_HC_OS_COMPONENTS" ("SNAPSHOT_GUID", "TYPE", "NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_VENDOR_SW_SUMMARY_IDX" ON "SYSMAN"."MGMT_HC_VENDOR_SW_SUMMARY" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_VENDOR_SW_COMPS_IDX" ON "SYSMAN"."MGMT_HC_VENDOR_SW_COMPONENTS" ("VENDOR_SOFTWARE_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_SYSTEM_ERROR_LOG_01" ON "SYSMAN"."MGMT_SYSTEM_ERROR_LOG" ("MODULE_NAME", "LOG_LEVEL", "OCCUR_DATE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_EMD_PING_IDX_01" ON "SYSMAN"."MGMT_EMD_PING" ("STATUS", "MAX_INACTIVE_TIME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."EMDW_TRACE_DATA_IDX_01" ON "SYSMAN"."EMDW_TRACE_DATA" ("CONTEXT_TYPE_ID", "LOG_TIMESTAMP", "LOG_LEVEL") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX02" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("SOURCE_TARGET_GUID", "ASSOC_TARGET_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX03" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("ASSOC_TARGET_GUID", "SOURCE_TARGET_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX01" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("SOURCE_TARGET_GUID", "IS_MEMBERSHIP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX04" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("ASSOC_TARGET_GUID", "IS_MEMBERSHIP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_CONTROLFILES_ECM_PK" ON "SYSMAN"."MGMT_DB_CONTROLFILES_ECM" ("ECM_SNAPSHOT_ID", "FILE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_ROLLBACK_SEGS_ECM_PK" ON "SYSMAN"."MGMT_DB_ROLLBACK_SEGS_ECM" ("ECM_SNAPSHOT_ID", "ROLLNAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_SGA_ECM_PK" ON "SYSMAN"."MGMT_DB_SGA_ECM" ("ECM_SNAPSHOT_ID", "SGANAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_TABLESPACES_ECM_PK" ON "SYSMAN"."MGMT_DB_TABLESPACES_ECM" ("ECM_SNAPSHOT_ID", "TABLESPACE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_DATAFILES_ECM_PK" ON "SYSMAN"."MGMT_DB_DATAFILES_ECM" ("ECM_SNAPSHOT_ID", "TABLESPACE_NAME", "FILE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_SQL_SUMMARY_PK" ON "SYSMAN"."MGMT_SQL_SUMMARY" ("TARGET_GUID", "SNAP_ID", "ADDRESS", "HASH_VALUE", "PLAN_HASH_VALUE", "PIECE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_SQL_PLAN_PK" ON "SYSMAN"."MGMT_SQL_PLAN" ("TARGET_GUID", "SNAP_ID", "ADDRESS", "HASH_VALUE", "PLAN_HASH_VALUE", "ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_RECUSERSETTINGS_ECM_PK" ON "SYSMAN"."MGMT_DB_RECUSERSETTINGS_ECM" ("ECM_SNAPSHOT_ID", "USER_NAME", "PROBLEM_CODE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_RECSEGMENTSETTINGS_PK" ON "SYSMAN"."MGMT_DB_RECSEGMENTSETTINGS_ECM" ("ECM_SNAPSHOT_ID", "OBJ_TYPE", "OBJ_OWNER", "OBJ_NAME", "OBJ_PARTITION", "OBJ_LOB_COL", "SEGMENT_TYPE", "PROBLEM_CODE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_INVOBJS_ECM_PK" ON "SYSMAN"."MGMT_DB_INVOBJS_ECM" ("ECM_SNAPSHOT_ID", "OBJECT_TYPE", "OBJECT_OWNER", "OBJECT_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "APEX_030200"."WWV_FLOW_SW_RESULT_IDX3" ON "APEX_030200"."WWV_FLOW_SW_RESULTS" ("SECURITY_GROUP_ID", "ID", "STATUS") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "APEX_030200"."WWV_FLOW_SW_D_RESULT_IDX3" ON "APEX_030200"."WWV_FLOW_SW_DETAIL_RESULTS" ("SECURITY_GROUP_ID", "RESULT_ID", "FILE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "APEX_030200"."WWV_FLOW_SW_STMTS_IDX3" ON "APEX_030200"."WWV_FLOW_SW_STMTS" ("SECURITY_GROUP_ID", "FILE_ID", "ISRUNNABLE", "STMT_ID", "STMT_NUMBER") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
最新发布
08-16
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值