Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> URGENT: Full Export break with too many open cursor

URGENT: Full Export break with too many open cursor

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Fri, 10 Dec 2004 09:28:04 +0100
Message-ID: <41b95e12$0$16041$9b4e6d93@newsread4.arcor-online.net>


Hello

a well running export script of my database breaks now with

EXP-00008: ORACLE-Fehler 604 gefunden
ORA-00604: Fehler auf rekursiver SQL-Ebene 1
ORA-01000: Maximale Anzahl offener Cursor überschritten
EXP-00000: Der Export-Vorgang endete mit Fehlern

ORA-01000 says too many open cursors. This can't be true. In initora are 1000 defined. A select of all says there are actually around 140 when starting the export.

Could someone tell me what the problem?

thanks
ralf Received on Fri Dec 10 2004 - 02:28:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US