ORA-01000: maximum open cursors exceeded

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Sun, 31 Mar 2002 19:08:24 -0800
Message-ID: <F001.004377D1.20020331190824@fatcity.com>

Hi Gurus,

Every week, we do a logical export of the whole production database. It used to work until I encounter the "ORA-01000: maximum open cursors exceeded"

Command : exp userid='system/system_pwd' file=$ORA_EXP_FILE grants=y rows=y constraints=y compress=y full=y inctype=complete log=$ORA_EXP_LOG Error message :

                Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production

		With the Partitioning option
		JServer Release 8.1.6.1.0 - Production
		Export done in US7ASCII character set and US7ASCII NCHAR

character set

		About to export the entire database ...
		. exporting tablespace definitions
		EXP-00008: ORACLE error 604 encountered
		ORA-00604: error occurred at recursive SQL level 1
		ORA-01000: maximum open cursors exceeded

EXP-00000: Export terminated unsuccessfully

Qn :
* Before exporting, we startup the database in restrict mode. Is it the same for you gurus out there ?
* If I were to increase the cursor, how many should I increase to
(Current value=300) ?

Please help. TIA

Regds,
New Bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Sun Mar 31 2002 - 21:08:24 CST