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