[QUOTE][i]Originally posted by slam [/i]
[B]Hello,

Try to use the command:
drop schema_name cascade
this should drop the entire schema and all the user objects.

Good luck,

SLAM. [/B][/QUOTE]
Try:
DROP USER schema_name CASCADE
will drop the user and all the objects he/she owns. This is a pretty drastic measure, however.

Check your data dictionary tables to make sure Oracle knows about the object you are trying to drop. Check DBA_OBJECTS and DBA_MVIEW_DETAIL_RELATIONS to make sure your view is defined as you think. You might have a data dictionary problem.

Also, check out [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/state23a.htm#2067091[/url] for syntax...