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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Out of cursors / Error on recursion lvl1 in Sql*Plus...

Re: Out of cursors / Error on recursion lvl1 in Sql*Plus...

From: Andreas Koch <mail_at_kochandreas.com>
Date: Mon, 20 Aug 2001 21:35:35 +0200
Message-ID: <3B816687.AA2D740D@kochandreas.com>

Frank schrieb:

> I would guess that the import utility also uses queries, and hence use from
> the open_cursor pool.
> Could it be that you use to shutdown/startup the database sometimes, and
> other times not,
> then when you don't stop/start it you next query creates the error???

Hmm... don't think so, the database is started on computer startup, and pratically never shut down. Also when importing on other systems, even with much larger dumpfiles, it usually doesn't happen...

-- 
                                              Andreas
Mach's mit  /-\
            |o|
            \-/  gib KIDS keine Chance! ;-)
Received on Mon Aug 20 2001 - 14:35:35 CDT

Original text of this message

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