Unable to remove a user in Oracle 11g I have a streams replication  related user in Oracle 11g. I see the user in dba_users table and was anle to login using the user but when I try to drop the user i get the error. 

SQL&gt; drop user &lt;username&gt; cascade;  
Error at line 1:  
ORA-1403: no data found.  


Loos like data got corrupted in internal tables. 

Any idea how to fix this mess and remove the user?
The ORA-01403 seems to indicate that you have a System Event Trigger for DROP USER.

You'll need to hunt down the appropriate trigger.

SELECT *
from dba_triggers
where base_object_type like 'DATABASE%'
and triggering_event like 'DROP%'
and status='ENABLED'
;


If that doesn't work, then I recommend that you open a ticket with Oracle Support.