ORA-00036

今天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'

发现这个错误. 应该是最终的错吧

说这个用户下使用该表空间的的配额不够.

一般开发测试库都不会设置用户的配额的. 以及生产库都不会设.

进去看了下.没设置空间配额. 顺便设置下无限配额 就好了