Cannot drop a table?!?!

Hi,

I have a table that when i want to drop it it gives an error:

'Use DROP MATERIALIZED VIEW' to drop the table

but when I want to drop it using DROP MATERIALIZED VIEW or DROP SNAPSHOT it gives:

'Materialized view does not exist'

So how can I override this and drop the table? I need to drop the whole schema, but I cannot since I cannot driop this table. Is there another way to drop the schema? or the table?

Thanx!

Hello,

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

Good luck,

SLAM.

Quote:

---

Originally posted by slam
Hello,

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

Good luck,

SLAM.

---

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 http://technet.oracle.com/docs/produ...3a.htm#2067091 for syntax...