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.