Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01000 when altering table
Has anyone encountered the ORA-01000: maximum number of cursors exceeded
error when trying to add a column to a table using the ALTER TABLE command.
I changed the value of OPEN_CURSORS from default of 50 up to 200 and still
received the error. It is not a large table (51 columns/about 5000 rows).
Any direction or guidance would be appreciated.
Thanx in advance Received on Mon Jun 22 1998 - 16:11:15 CDT