ORA-00036

34rfdw

今天C开发的同事说 有条插入语句插不进菊花啊 报错呢!
insert into sp_dft values('63025840', 0, 3, 1, '11111111', 0, 0, 0, NULL, NULL)
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels () exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels () exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels () exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels () exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels () exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels () exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00036: maximum number of recursive SQL levels () exceeded
ORA-00036: maximum number of recursive SQL levels (50) exceeded

一看是插入语句引起后台的递归.  反复检查用户下的触发器和该表的外键.以及SYS用户下的触发器.都没有涉及该表的
稍休息片刻 先把所有的触发器暂停下
在SYS用户下禁用所有的触发器
SQL> insert into sp_dft values('63025840', 0, 3, 1, '11111111', 0, 0, 0, NULL, NULL);
insert into sp_dft values('63025840', 0, 3, 1, '11111111', 0, 0, 0, NULL, NULL)
ORA-01536: space quota exceeded for tablespace 'GBPOSP'
发现这个错误. 应该是最终的错吧
说这个用户下使用该表空间的的配额不够.
一般开发测试库都不会设置用户的配额的. 以及生产库都不会设.
进去看了下.没设置空间配额. 顺便设置下无限配额 就好了

yuxing

我难过的是你在问我难过什么我害怕的是把我害怕的事情说出来