MVIEW not getting dropped
I am working on Oracle 10.2.0.4 database.
I am trying to drop a materialized view by command,
drop materialized view <mview_name>;
This command is going into a long running session and mview is not getting dropped.
I have made all the jobs which do automatic fast refresh of this mview offline.
Please can anybody suggest how to proceed on this.
Regards,
Vaibhav