Toad World® Forums

Drop Materialized View in the schema browser (Toad 12.7 - Oracle 11.2.0.4.0)

Hello everybody,

if I would drop a materialized view, Toad show me the following error:

SQL> DROP VH.VERTRAGSHISTORIE

DROP VH.VERTRAGSHISTORIE
Error at line 2
ORA-00950: Ungültige DROP-Option
Script Terminated on line 2.
Time End: 24/07/2015 09:36:10
Elapsed Time for Script Execution: 42209 days09:36:10 %0:s hours

But I can drop the matview with the following command without errors:

drop materialized view VH.VERTRAGSHISTORIE

Best Regards

Jochen

Hey, what do you have selected as object type? Tables or MVs?

Kind regards, Hans

Even with tables selected it works perfectly for me (12.7).

If you have a valid license you should raise an SR.

I have created an SR. :wink:

Thanks!

This has been fixed for the next beta.