Chris, Add the following in your init.ora. event = "1652 trace name errorstack level 3". And check the user dump destination after u encounter the error.
In case, downtime is not an option, or you cannot set it at the individual
session levels , another way of doing it is by coding for a servererror on
database trigger, and then maybe, use dbms_system.ksdwrt to write the error
details in the alert log. I leave it to you to figure out the rest.
Hope this helps.
Raj
Chris Stephens
<ChrisStephens@a To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ffina.com> cc:
Sent by: Subject: temp space
[EMAIL PROTECTED]
January 17, 2003
09:54 AM
Please respond
to ORACLE-L
anyone know how to identify the session that caused a ORA-1652?
-thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
