今天在插入数据的时候出现ora-01536:space quota exceeded for tablespace **.
我的插入语句为:insert into TBLENGPROCESSNODEMASTER (NODEID, PROCESSNO, NODENO, NODETYPE, GROUPNO, CHECKIOOPTION, CREATOR, CREATEDATE, REVISER, REVISEDATE, MEMO, OPTYPE, POSITIONX, POSITIONY, FACTORYNO, DEPARTMENTNO, CYCLETIME, YIELDRATE, ACCUMCYCLETIME, ACCUMYIELDRATE, LINENO)
values ('N228AA6001B20-0000', 'N228AA6001B20', 'LAM_CUT', 0, 0, 0, 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), '', null, '435', '300', 'TJ2', '', '0', 0.0000, '0', 0.0000, 'A');
但是如果我把插入语句改为insert into TBLENGPROCESSNODEMASTER (NODEID, PROCESSNO, NODENO, NODETYPE, GROUPNO, CHECKIOOPTION, CREATOR, CREATEDATE, REVISER, REVISEDATE, MEMO, OPTYPE, POSITIONX, POSITIONY, FACTORYNO, DEPARTMENTNO, CYCLETIME, YIELDRATE, ACCUMCYCLETIME, ACCUMYIELDRATE, LINENO)
values ('N228AA6001B20-000', 'N228AA6001B20', 'LAM_CUT', 0, 0, 0, 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), '', null, '435', '300', 'TJ2', '', '0', 0.0000, '0', 0.0000, 'A');这样又可以正常插入。不知道什么原因?好奇怪,应该不是表空间的问题吧?我的字符串也没有超过字符串定义的长度呀?希望那位高手能帮指点。谢谢!!
我的插入语句为:insert into TBLENGPROCESSNODEMASTER (NODEID, PROCESSNO, NODENO, NODETYPE, GROUPNO, CHECKIOOPTION, CREATOR, CREATEDATE, REVISER, REVISEDATE, MEMO, OPTYPE, POSITIONX, POSITIONY, FACTORYNO, DEPARTMENTNO, CYCLETIME, YIELDRATE, ACCUMCYCLETIME, ACCUMYIELDRATE, LINENO)
values ('N228AA6001B20-0000', 'N228AA6001B20', 'LAM_CUT', 0, 0, 0, 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), '', null, '435', '300', 'TJ2', '', '0', 0.0000, '0', 0.0000, 'A');
但是如果我把插入语句改为insert into TBLENGPROCESSNODEMASTER (NODEID, PROCESSNO, NODENO, NODETYPE, GROUPNO, CHECKIOOPTION, CREATOR, CREATEDATE, REVISER, REVISEDATE, MEMO, OPTYPE, POSITIONX, POSITIONY, FACTORYNO, DEPARTMENTNO, CYCLETIME, YIELDRATE, ACCUMCYCLETIME, ACCUMYIELDRATE, LINENO)
values ('N228AA6001B20-000', 'N228AA6001B20', 'LAM_CUT', 0, 0, 0, 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), 'DAA0018', to_date('20-04-2006', 'dd-mm-yyyy'), '', null, '435', '300', 'TJ2', '', '0', 0.0000, '0', 0.0000, 'A');这样又可以正常插入。不知道什么原因?好奇怪,应该不是表空间的问题吧?我的字符串也没有超过字符串定义的长度呀?希望那位高手能帮指点。谢谢!!
在预先分配的空间没有用完前,当然可以继续insert了。
只是不能再分配新的空间而已。