sqlldr数据时遇到ORA-26026如何解决？

zhaoqinghu

SQL*Loader: Release 10.2.0.3.0 - Production on Wed Nov 4 11:29:10 2009

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

ORA-26026: unique index BOCOMQT.PK_CB_TRANFLW_RST initially in unusable state
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Load completed - logical record count 2141.

zhaoqinghu

查了以下资料有如下：

ORA-26026 unique index string.string initially in unusable state

Cause: A unique index is in IU state (a unique index cannot have index maintenance skipped via SKIP_UNUSABLE_INDEXES).

Action: Either rebuild the index or index partition, or use SKIP_INDEX_MAINTENANCE if the client is SQL*Loader.



欧劳- 26026：  unique index string . string initially in unusable state唯一索引的字符串 。最初是在用状态字符串  
Cause: 原因：  A unique index is in IU state (a unique index cannot have唯一索引在国际单位状态（唯一的索引不能有
* index maintenance skipped via SKIP_UNUSABLE_INDEXES). *索引维护跳过通过SKIP_UNUSABLE_INDEXES）。


Action: 行动：  Either rebuild the index or index partition, or use要么重新建立索引或索引分区，或者使用
* SKIP_INDEX_MAINTENANCE if the client is SQL*Loader. * SKIP_INDEX_MAINTENANCE如果客户端是SQL * Loader的。



=======================================
建表中指定主键会自动生成索引，这个索引如何重建？是否可以删除该唯一索引

renxiao2003

从错误看，是主键（唯一索引重复了吧）