查找并删除重复记录 ORA-02292

最新推荐文章于 2024-09-18 17:35:21 发布
最新推荐文章于 2024-09-18 17:35:21 发布
阅读量1.2k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： Oracle SQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/Tigers23/article/details/8255138

查找数据库中某个字段存在的重复记录

select * from sys_server_info where server_rm in(select server_rm from sys_server_info groupby server_rm havingsum(1)>1)

现在只想保留一条记录删除重复的记录

删除数据的时候报错ORA-02292：违反完整约束件（）-已找到自己录

取消主键约束

altertable sys_server_info disableconstraint PK_SYS_SERVER_INFO

报错又报错“ORA-02297: 无法禁用约束条件 (UNITELE.PK_SUB_TASK_T) - 存在相关性"

altertable sys_server_info disableconstraint PK_SYS_SERVER_INFO cascade

或者

ALTERTABLE sys_server_info MODIFYCONSTRAINT PK_SYS_SERVER_INFO DISABLE; ----这两个语句都是取消主键约束的

完成之后添加主键约束

altertable sys_server_info enableconstraint PK_SYS_SERVER_INFO

Oracle报错：ORA-02292: 违反完整约束条件 - 已找到子记录问题解决
黄团团的个人博客
06-19 3337
### Cause: java.sql.SQLException: ORA-02292: 违反完整约束条件 (TEST.FK_TEST_FUE) - 已找到子记录 ; ORA-02292: 违反完整约束条件 (TEST.FK_TEST_FUE) - 已找到子记录 ; nested exception is java.sql.SQLException: ORA-02292: 违反完整约束条件 (TEST.FK_TEST_FUE) - 已找到子记录
Oracle错误代码查询(超详细)
qq_24542879的博客
02-01 1527
使用Ctrl + F 查找错误代码序号 ORA-00001: 违反唯一约束条件 (.) ORA-00017: 请求会话以设置跟踪事件 ORA-00018: 超出最大会话数 ORA-00019: 超出最大会话许可数 ORA-00020: 超出最大进程数 () ORA-00021: 会话附属于其它某些进程；无法转换会话 ORA-00022: 无效的会话 ID；访问被拒绝 ORA-00023: 会话引...
主键与外键之ORA-02292: integrity constraint
David
07-06 1690
今天在删除一个表某条记录时，出现如下错误：ORA-02292: integrity constraint (CICRO.FK8A82499F4C67C41) violated - child record found于是查看了相关的主键和约束关系，发现了一些问题。关于这个错误，oracle官方解决方法是：Error: orA-02292: integrity constraint <cons...
Oracle的ORA-02292报错：违反完整性约束，已找到子记录
weixin_30273501的博客
02-11 840
第一种方法： 第一步就是找到子表的记录： select a.constraint_name, a.table_name, b.constraint_name from user_constraints a, user_constraints bwhere a.constraint_type = 'R' and b.constraint_type = 'P' and a.r_constraint...
Oracle 错误 ”ORA-02292“
发展是曲折的但也是前进的
10-10 1939
Oracle提示的错误已经很明显了，您在没有删除子表记录的情况下，删除主表记录，触发了完整性约束错误。 方法如下： （方法1）将数据完整性约束交给Oracle处理 您测试一下，在sqlplus中，直接删除有子表记录的主表记录，如果能删除，可以不用在Hibernate中设置数据完整性。 （方法2）将数据完整性约束交给Hibernate，在Hibernate设置好主子表关系，以及级联删除，这样
Oracle中错误代码ORA-02292
weidongke的专栏
04-21 923
当删除oracle中一张表的记录，报ORA-02292错，是违反了完整性约束条件。 解决方法： 1、禁用约束：alter table 表名 disable constraint 主键约束名 CASCADE 2、删除A表的数据 3、启用约束：alter table 表名 enable constraint 主键约束名 ...
ora-31684
08-12
用户说：“我想用户意图是查找关于Oracle数据库错误ORA-31684的解决方案或解释。请问Oracle数据库错误ORA-31684原因及解决方法”。所以，我需要提供这个错误的解释和解决方案。 现在，回顾系统级指令： - 所有行内...
ora-00001
03-28
- **删除重复记录**：若为无效数据，直接删除重复项。 - **使用 `MERGE` 语句**：合并插入与更新操作，避免冲突。 ```sql MERGE INTO employees dest USING (SELECT 100 AS id, 'Alice' AS name FROM dual) src...
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
对于唯一索引，检查并删除重复数据（解决ORA-01452）。 5. 确保所有表都已创建（处理延迟段创建问题）。 示例操作流程： 1. 导入数据（跳过索引）： ```bash impdp system/password directory=DPUMP_DIR ...
oracle ORA-00001: unique constraint
08-02
首先，用户的问题是：“Oracle ORA-00001 unique constraint violation error fix”，意思是Oracle数据库中的唯一约束冲突错误（ORA-00001）的修复方法。 根据系统级指令： - 所有行内数学表达式必须使用$...$格式...
【Oracle】ORA-02292: integrity constraint
09-18 1005
识别相关表和约束、查找依赖关系。删除子记录 或 临时禁用约束。
oracle ORA-02292: 违反完整约束条件
weixin_34120274的博客
04-17 529
我是处于工作中没用过oracle的状态，这不，记录下这个小小的问题。哈哈。 表是公司的平台组定义的。前几天为了测试程序，想删掉一些记录，然后使用delete语句，出现这个东东：oracle ORA-02292: 违反完整约束条件 (TEST.FK_H3K23R74VBBA62WXJB512P0PB) - 已找到子记录出现原因是这个表的某个column被当成了别的表的外键，真的是尴尬，说实话，工作...
02292oracle,Oracle教程：ORA-02292和ORA-02297
weixin_33316366的博客
04-05 260
删除某表的数据，报错“ORA-02292: 违反完整约束条件 (UNITELE.TA_SUB_REFERENCE3) - 已找到子记录”。原来该表有主键，随即置主键约束无效ALTER TABLE table_name MODIFY CONSTRAINT PK_SUB_TASK_T DISABLE;又报错“ORA-02297: 无法禁用约束条件 (UNITELE.PK_SUB_TASK_T) - 存...
ORA-02292和ORA-02297
Claude's Vision
07-31 1066
删除某表的数据，报错“ORA-02292: 违反完整约束条件 (UNITELE.TA_SUB_REFERENCE3) - 已找到子记录”。原来该表有主键，随即置主键约束无效 ALTER TABLE table_name MODIFY CONSTRAINT PK_SUB_TASK
ORA-02292: 违反完整约束条件
Daneliya的博客
03-02 2466
1.问题 Type Exception Report Message Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Description The server encountered an unexpected condition...
Oracle ORA-02292: 违反完整约束条件 (UNITELE.TA_SUB_REFERENCE3) - 已找到子记录
码过烟云
02-18 8183
A表被B表引用，删除A表的时候提示ORA-02292，A表的主键被引用了，虽然已经把B表的数据全部删除掉，但仍然删除不了A表的数据。 解决办法： 用禁用约束语句把A表的主键约束给禁用掉。 1、禁用约束：alter table 表名 disable constraint 主键   CASCADE 2、删除A表的数据 3、启用约束：alter table 表名 enable constrai
ORA-02292: 违反完警约束条件(ARCHIVEFKA61AFE71150283EF)- 已找到子记录
asffsfassaffs的博客
03-05 581
ORA-02292: 违反完警约束条件(ARCHIVEFKA61AFE71150283EF)- 已找到子记录
Oracle删除表数据报：ora-02292:违反完整约束条件
dxjren的博客
11-29 5344
Oracle删除表数据报：ora-02292:违反完整约束条件
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值