Use drop materilaized view viewname;

that's enough.

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

check that also.