Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01000: maximum open cursors exceeded
Hey there,
i've programmed a tool which handles databaserows like delete/create etc. The whole thing is working very well till now. Im actually building scripts which generates plenty of new rows and now im getting this error:
ORA-01000: maximum open cursors exceeded
Im using Oracle DB10g on a W2000Pro-Machine with 2.5GB Ram.
Each row is created with getting a new available PrimaryKey for the table with:
SELECT <seqName>.nextval FROM dual
<seqName> is the name of the sequence which is used to create a new unique
PKey.
Its created by:
CREATE SEQUENCE "<seqName>" INCREMENT BY 1 START WITH 1 NOMAXVALUE
NOMINVALUE NOCYCLE
Is someone able to give me a hint whats wrong ? Im not this deep into
oracle-dbs at all.
thanks in advance,
oliver
Received on Fri Jun 16 2006 - 03:36:48 CDT