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
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