...
During large imports on Oracle, you could receive following error message:
Panel | |
---|---|
Html bobswift | ORA-01000: maximum open cursors exceeded
</pre> |
(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:
Panel | |
---|---|
Html bobswift | show parameter open_cursors
</pre> |
A listing similar to the following will display:
Panel |
---|
<pre>
SQL> show parameter open_cursors;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000
</pre> |
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:
Panel | |
---|---|
Html bobswift | alter system set open_cursors=1000
</pre> |
...
To make a permanent change, you must set the open_cursors
value in the initialization parameters file.