Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id hBII01G03166 for ; Thu, 18 Dec 2003 12:00:01 -0600 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id hBII00o03156 for ; Thu, 18 Dec 2003 12:00:00 -0600 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id hBIHo1mJ028277 for ; Thu, 18 Dec 2003 09:54:51 -0800 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id hBIHUoWa027987 for oracle-l@orafaq.com; Thu, 18 Dec 2003 09:30:50 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005DA539; Thu, 18 Dec 2003 09:34:25 -0800 Message-ID: Date: Thu, 18 Dec 2003 09:34:25 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Guang Mei" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Guang Mei" Subject: RE: ORA-1652: temp segment in tablespace SYSTEM ?!? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Are you sure they are not loading blobs into SYSTEM tablespace? Guang -----Original Message----- Sands, Robyn Sent: Thursday, December 18, 2003 11:29 AM To: Multiple recipients of list ORACLE-L This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C3C583.D0824CB6 Content-Type: text/plain hey everyone ... The developers are loading blobs over database links. One of the 24 subsets of data is failing with the following error: ORA-1652: unable to extend temp segment by 512 in tablespace SYSTEM The subset that is failing is reading a large amount of MRP data. The error occurs in the instance the data is being pulled from. Can someone help me figure out why is this occurring in 'SYSTEM'? All of the users involved in this process are set to use 'TEMP' as their temp space and the target tables are not in 'SYSTEM' either. I've queried v$session and v$sort_usage while the process is running, but all the sorts I see are in 'TEMP'. I've also checked dba_tables and dba_indexes, and aren't any stray objects in the 'SYSTEM' tablespace. What else should I look for? We have plenty of space in TEMP if I can get this process to use it. TIA ... Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: gmei@incyte.com 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: ListGuru@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).