oracle执行sql报错03113

Question

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;

Answer 1

select USERGROUPCODE
FROM ORG_GROUP2 WHERE GROUP_UUID = '2873e6c4ac2f412a8d4b5b1bacd0cedd'
这条语句一定要保证结果不是一个并且不能为空。
另外报的错误应该和语句没有关系，是你的数据库的归档日志有问题。可以将数据库切换到非归档模式：
http://www.cnblogs.com/xwdreamer/p/3910264.html