RE: temp space
Title: temp space after utilizing a pl/sql routine found on asktom.com we were able to catch the offending query that was consistently causing the 1652. (this isn't something that you can capture from the v$ views if the session has disconnected (at least i know of know way)) ...anyways the problem was that the relevant tables were not properly intexed and not the size of the temp space. thank you for the suggestions though. -Original Message-From: Bernardus Deddy Hoeydiono [mailto:[EMAIL PROTECTED]]Sent: Sunday, January 19, 2003 9:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: temp space Hi Chris, The error ORA-1652 is because of the temporary tablespace for the corresponding table is not enough. The temporary tablespace for the table normally assigned when create the table. Or when create the user. If you're not define the temporary tablespace when you create the table, the temporary tablespace will follow the temporay tablespace that already assign in the user creation. To solve this problem, please resize the teporary tablespace. Thank's Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris StephensSent: Friday, January 17, 2003 9:55 PMTo: Multiple recipients of list ORACLE-LSubject: temp space anyone know how to identify the session that caused a ORA-1652? -thank you
RE: temp space
Title: temp space Hi Chris, The error ORA-1652 is because of the temporary tablespace for the corresponding table is not enough. The temporary tablespace for the table normally assigned when create the table. Or when create the user. If you're not define the temporary tablespace when you create the table, the temporary tablespace will follow the temporay tablespace that already assign in the user creation. To solve this problem, please resize the teporary tablespace. Thank's Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris StephensSent: Friday, January 17, 2003 9:55 PMTo: Multiple recipients of list ORACLE-LSubject: temp space anyone know how to identify the session that caused a ORA-1652? -thank you
Re: temp space
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 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).
