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> drop user <username> 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?