My Oracle Support Banner

DROP USER FAILS WITH ORA-01418 (Doc ID 987468.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Standard Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

You cannot drop a user and gets following error:
The drop user command fails with ORA-01418, index does not exists.

After investigating, it seems that the dictionnary is corrupted: there are
values in obj$ with type 1 that do not exists in ind$

The output of the healthcheck script gives the following result:

HCheck Version 8i-11/1.51

Problem: OBJ$ INDEX entry has no IND$ entry
INDEX has no IND$ entry: Obj=75591 ODITEMP.TASK_TXT_FK1
INDEX has no IND$ entry: Obj=75585 ODITEMP.SESS_TXT_LOG_FK1
INDEX has no IND$ entry: Obj=75590 ODITEMP.PK_TASK_TXT
INDEX has no IND$ entry: Obj=75584 ODITEMP.PK_SESS_TXT_LOG
INDEX has no IND$ entry: Obj=75599 ODITEMP.PK_SESS_TASK_LOG

Found 5 potential problems and 1 warnings
Contact Oracle Support with the output
to check if the above needs attention or not

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.