Cannot drop a table?!?!

[siroracle]

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 <table_name> 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!

[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.

[marist89]

[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...