Drop User Error ORA-00604 ORA-01418

Situation:

After I failed to import Oracle schema (impdp),

I try to drop the user (drop user XXX cascade).

However, exception occurs

ORA-00604: error occurred at recursive SQL level 1

ORA-01418: specificed index does not exist

Environment:

Oracle 11gR2

Linux  2.6.18-128.el5

Possible Solution:

1. Log in Oracle as SYSDBA.

2. Find the user id.

SELECT USER# FROM USER$ WHERE NAME = 'XXX'

3. Find the related objects.

SELECT * FROM OBJ$ WHERE OWNER# = USER#

4. Remove the related objects.

DELETE FROM OBJ$ WHERE OWNER# = USER#

5. Drop the user again.

DROP USER XXX CASCADE
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s