删除视图的SQL语句

ppc

我们在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

谢谢楼主分享

dawang

看看，看看