Maximum open cursors have been exceeded

Problem

During large imports on Oracle, you could receive following error message:

(The cursors are used only during the import; they then are closed.)
 

Issue the following sql*plus utility command to check the current value for maximum open cursors:

A listing similar to the following will display:

Solution

An open_cursors value of 1000 should be sufficient for all large imports.

You can temporarily set the open_cursors value with the following SQL:

To make a permanent change, you must set the open_cursors value in the initialization parameters file.