ORA-12003 解决物化视图drop失败

SQL> drop table sp_hz_main_jtwfjl;
drop table sp_hz_main_jtwfjl
*
ERROR 位于第 1 行:
ORA-12083: 必须使用 DROP MATERIALIZED VIEW 来删除 “WFHZ”.”SP_HZ_MAIN_JTWFJL”

SQL> drop materialized view sp_wf_main_jtwfjl;
drop materialized view sp_wf_main_jtwfjl
*
ERROR 位于第 1 行:
ORA-12003: 快照”WFHZ”.”SP_WF_MAIN_JTWFJL”不存在

用on prebuilt table 选项重建物化视图，然后再删除
create table test as select * from SP_HZ_MAIN_JTWFJL;
alter table test add primary key ……
create materialized view log on test;
create materialzied view SP_HZ_MAIN_JTWFJL on prebuilt table as select * from test;
drop materialized view SP_HZ_MAIN_JTWFJL ;