------_=_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
- - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - -
This e-mail and any attachments may contain information which is confidential,
proprietary, privileged or otherwise protected by law. The information is solely
intended for the named addressee (or a person responsible for delivering it to the
addressee). If you are not the intended recipient of this message, you are not
authorized to read, print, retain, copy or disseminate this message or any part of it.
If you have received this e-mail in error, please notify the sender immediately by
return e-mail and delete it from your computer.
------_=_NextPart_001_01C3C583.D0824CB6
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=953251116-18122003>hey everyone
...</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=953251116-18122003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=953251116-18122003>The developers are
loading blobs over database links. One of the 24 subsets of data is
failing with the following error:</SPAN></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial><SPAN
class=953251116-18122003></SPAN></FONT><FONT face=Arial><SPAN
class=953251116-18122003></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=953251116-18122003>
</SPAN>ORA-1652: unable to extend temp segment by 512 in
tablespace SYSTEM</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=953251116-18122003><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=953251116-18122003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT size=2><SPAN class=953251116-18122003><FONT face=Arial>Can someone
help me figure out why </FONT></SPAN><SPAN class=953251116-18122003><FONT
face=Arial>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.</FONT></SPAN></FONT></DIV>
<DIV><SPAN class=953251116-18122003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953251116-18122003><FONT face=Arial size=2>TIA ...
Robyn</FONT></SPAN></DIV>
<DIV><SPAN class=953251116-18122003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT SIZE=3><BR>
<BR>
- - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - - <BR>
This e-mail and any attachments may contain information which is confidential,
proprietary, privileged or otherwise protected by law. The information is solely
intended for the named addressee (or a person responsible for delivering it to the
addressee). If you are not the intended recipient of this message, you are not
authorized to read, print, retain, copy or disseminate this message or any part of it.
If you have received this e-mail in error, please notify the sender immediately by
return e-mail and delete it from your computer.<BR>
</FONT>
</BODY></HTML>
------_=_NextPart_001_01C3C583.D0824CB6--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sands, Robyn
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).
