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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
