Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01000 when altering table

ORA-01000 when altering table

From: D Morrow <morrowd_at_ci.portsmouth.va.us>
Date: 22 Jun 1998 21:11:15 GMT
Message-ID: <01bd9e22$51b169a0$7602070a@MorrowD.ci.portsmouth.va.us>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US