删除视图的SQL语句

xiangzhao

我们在MAXIMO中创建视图，经常发现configdb后weblogic无法正常启动，这个时候您需要删除视图怎么办了，我将语句抽取了一下，希望对大家有用。

（注：为什么不能启动，哈哈，大家自己分析了）
在PLSQL DEVELOPER中执行如下语句：

delete from maxview where viewname = 'ITEMTEST';
delete from maxviewcfg where viewname = 'ITEMTEST';
delete from maxviewcolumn where viewname = 'ITEMTEST';
delete from maxviewcolumncfg where viewname = 'ITEMTEST';
delete from maxobject where objectname = 'ITEMTEST';
delete from maxobjectcfg where objectname = 'ITEMTEST';
delete from maxattribute where objectname = 'ITEMTEST';
delete from maxattributecfg where objectname = 'ITEMTEST';
commit;
drop view ITEMTEST;

jskhfw

。。。。。。。