This content has been marked as final. Show 3 replies
Thank you Richard!
It's hard to find Japanese forum...
My question is I can't drop materialized view.
1.I could drop table same name as materialized view.
2.drop materialized view statement is normally successd.
3.but create materialized view is not successed.
4.select object_name from user_object shows the materialized view is alive.
I will try to drop user or tablespace tomorrow.
Anyway, thank you for your kindness,