ORACLE下执行下面的sql报错,错误code03113,求大神指点原因
select * from ( select * from ORG_GROUP2 where LOGICDELETE = '0'
AND PROVINCEID = 'organization'
AND USERGROUPCODE LIKE (select USERGROUPCODE
FROM ORG_GROUP2 WHERE GROUP_UUID = '2873e6c4ac2f412a8d4b5b1bacd0cedd')||'%'
AND GROUP_UUID != '2873e6c4ac2f412a8d4b5b1bacd0cedd'
ORDER BY DISPLAYORDER,GROUP_UUID ) where rownum <= 10;
select USERGROUPCODE
FROM ORG_GROUP2 WHERE GROUP_UUID = '2873e6c4ac2f412a8d4b5b1bacd0cedd'
这条语句一定要保证结果不是一个并且不能为空。
另外报的错误应该和语句没有关系,是你的数据库的归档日志有问题。可以将数据库切换到非归档模式:
http://www.cnblogs.com/xwdreamer/p/3910264.html