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

Toad for Oracle
1

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

2

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

Kind regards, Hans

3

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

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

4

I have created an SR. :wink:

Thanks!

5

This has been fixed for the next beta.