User cannot be dropped

Hi,

I want to drop a user, (with the CASCADE clause), but it says that i should first drop one materialized view. But when i try to drop it it says there is no such materizlized view/snapshot. It gives the snapshot in listings of tables, and when i try it to drop it as a table it says it should be dropped using DROP MATERIALIZED VIEW. So how do i drop this M VIEW? so i can drop the user?

Thanx!

Use drop materilaized view viewname;

that's enough.

if you a session of the user then u cannot drop him.

check that also.