ORA-01000: Maximum open cursors exceeded when performing database copy
437708Apr 30 2009 — edited May 5 2009Hi all,
We're trying to use SQL Developer to export data from one Oracle database and import it into another. The "Database copy" function seems like it would work quite well, but unfortunately about half way through the transfer we get many of these errors:
Inserted 23 rows into STAGE_SINET_PROG_TYPE in 0ms
Unable to perform batch insert.
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Unable to perform batch insert.
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Unable to perform batch insert.
ORA-01000: maximum open cursors exceeded
Unable to perform batch insert.
ORA-01000: maximum open cursors exceeded
Unable to perform batch insert.
ORA-01000: maximum open cursors exceeded
Unable to perform batch insert.
ORA-01000: maximum open cursors exceeded
Leaving the transfer incomplete. Is this a bug in SQL Developer, or is there a way around this? I've seen some reference to the DBAs being able to tweak an option on our server, but as this is a shared database it's not an option for us.
Why does SQL Developer need so many cursors anyway?
Thanks,
Adam.