`

Index XXX or partition of such index is in unusable state

阅读更多
问题:
删除oracl数据库中某张表的某条记录时报错:
index   "SYS.IX_target"   or   partition   of   such   index   is   in   unusable   state
解决方案:
--查询UNUSABLE状态的index
select index_name, status, owner from
dba_indexes where STATUS = 'UNUSABLE';

--组装重新编译index的sql语句
select 'alter index '||owner||'.'||index_name||' rebuild;' from
dba_indexes where STATUS = 'UNUSABLE';

--执行组装好的语句
alter index SYS.IX_target rebuild;
分享到:
评论

相关推荐

    Active@ Partition Recovery v.5.0.357 Enterprise Toolkit. Retail

    Active@ File Recovery utility is also included to allow you to save your files and folders in case of unsuccessful partition recovery (for example, the file system itself is severely damaged and ...

    微软内部资料-SQL性能优化5

    However, if we are searching for multiple rows, such as duplicate values, or keys in a range, anything more than a small number of rows will make the nonclustered index search very inefficient. ...

    oracle_partition_index.zip_partition

    本资料“oracle_partition_index.zip_partition”着重讨论了Oracle分区和索引的相关知识,下面将对这些主题进行详细解释。 一、Oracle分区 1. 分区概念:Oracle分区是将一个大表或索引分成多个较小、更易管理的...

    mysql-partition-and-Index.rar_partition

    本文件“mysql-partition-and-Index.rar_partition”着重介绍了这两个概念,结合实际操作示例进行深入讲解。 **分区(Partitioning)** MySQL的表分区是一种将大表物理分割成更小、更易管理的部分的方法。它将数据...

    Recovery Partition Creator 4.0.4.zip

    Recovery Partition Creator 4.0.4 is used to recreate the "Recovery Partition" of macOS system on MBP,iMac and Mac Mini etc. It is compatible with the macOS10.9 or greater. It can work on the last ...

    Recovery Partition Creator 3.8

    Recovery Partition Creator 4.0.4 is used to recreate the "Recovery Partition" of macOS system on MBP,iMac and Mac Mini etc. It is compatible with the macOS10.9 or greater. It can work on the last ...

    Jewels.of.Stringology.PDF

    The term "stringology" is a popular nickname for text algorithms, or algorithms on strings. This book deals with the most basic algorithms in the area. Most of them can be viewed as "algorithmic ...

    Partition Table in MS SQL Server

    4. **调整分区**:如果需要,可以使用`ALTER PARTITION FUNCTION`语句来分裂或合并分区,如增加新的边界值或合并现有分区。 ```sql ALTER PARTITION FUNCTION myRangePF () SPLIT RANGE (500); ALTER PARTITION ...

    Pose Partition Network pre-trained model

    The proposed PPN is favorably featured by low complexity and high accuracy of joint detection and partition. In particular, PPN performs dense regressions from global joint candidates within a ...

    微软内部资料-SQL性能优化2

    A stack is an area of memory in which program procedure or function call addresses and parameters are temporarily stored. In Process To run in the same address space. In-process servers are loaded ...

    EASEUS Partition Master 6.5.1 - Best Free Magic Partition Manager

    As Partition Magic alternative, EASEUS Partition Master freeware is an ALL-IN-ONE partition software and the most convenient hard disk partition manager toolkit including Partition Manager, Disk & ...

    Informatica如何添加Partition

    【Informatica Partition 知识详解】 Informatica Partition 是一种优化数据处理性能的机制,它允许一个 Session 在执行时使用多线程,从而提高数据加载的速度和效率。默认情况下,每个 Session 只有一个 Partition...

    磁盘分区PartitionManager

    《磁盘分区PartitionManager在Windows平台的应用与管理》 磁盘分区是计算机系统管理存储空间的重要方式之一,它能够帮助用户有效地组织和利用硬盘资源。PartitionManager是一款专为Windows平台设计的优秀磁盘分区...

    partition by 使用说明

    Partition By 函数使用说明 Partition By 函数是 SQL 语句中的一种功能强大且广泛应用的函数,它可以将查询结果按照一定的规则进行分区,并对每个分区进行独立的处理。在本文中,我们将详细介绍 Partition By 函数...

    算法上机!!

     A multistage graph is a graph (1) G=(V,E) with V partitioned into K >= 2 disjoint subsets such that if (a,b) is in E, then a is in Vi , and b is in Vi+1 for some subsets in the partition; and (2) | ...

    partition图像分割_partition_

    在图像处理领域,"partition图像分割"是一种常见的技术,它涉及到将一幅图像划分为多个子区域或部分。在这个特定的场景中,我们看到一个名为"girl"的图像被分割成2行4列的小块,形成了一个2*4的图像矩阵。这种分割...

    ORACLE重建索引总结

    使用`ALTER INDEX indexname REBUILD PARTITION partitionname TABLESPACE tablespacename`或`ALTER INDEX indexname REBUILD SUBPARTITION partitioname TABLESPACE tablespacename`命令,可以根据需要改变索引的...

    SQLServer中Partition By及row_number 函数使用详解

    在SQL Server中,`PARTITION BY` 和 `ROW_NUMBER()` 是两种非常重要的分析函数,它们在处理大数据集时尤其有用。本文将详细讲解这两个函数的使用方法及其在实际场景中的应用。 `PARTITION BY` 关键字是分析函数的一...

    oracle partition 深入讨论

    Oracle Partition 深入探讨 Oracle Partition 是一种数据库优化技术,它将大型表和索引分解为更小、更易管理的部分,称为分区。这一特性旨在解决支持非常大的表和索引时所面临的挑战。通过分区,可以对数据库对象...

Global site tag (gtag.js) - Google Analytics