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!