This content has been marked as final. Show 3 replies
Hmm, this is chinese for me ;-)
I was in the impression that this is an English forum.
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,
You may need to purge the recycle bin after dropping before re-creating using the same name.
This question has nothing to do with objects, so it does not really belong in the objects sub-forum. It probably belongs in the SQL and PL/SQL sub-forum.