FW: Error after resize of LMT
, so I > though > I'd ask if anyone has encountered this error. And i= f it occurred, how > severe > were the consequences? I can't apply the 9.2.0.4 pa= tch because the > vendor > says they don't support that yet. Thanks. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-= 538-5051 http://www.fatcity.com"; TARGET=3D"_blank">http://www.fa= tcity.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 'L= istGuru') 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 (l= ike subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Swee= pstakes http://hotjobs.sweepstakes.yahoo.com/signingb= onus" TARGET=3D"_blank">http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-50= 51 http://www.fatcity.com"; TARGET=3D"_blank">http://www.fatcity.= com San Diego, California = ; -- Mailing list and web hosting services = - To REMOVE yourself from this mailing list, send an E-Mai= l message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGu= ru') and in the message BODY, include a line containing: UNSUB ORACL= E-L (or the name of mailing list you want to be removed from= ). You may also send the HELP command for other information (like s= ubscribing). - - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - - This e-mail and any attachments may contain information which is confidenti= al, proprietary, privileged or otherwise protected by law. The information = is solely intended for the named addressee (or a person responsible for del= ivering it to the addressee). If you are not the intended recipient of this= message, you are not authorized to read, print, retain, copy or disseminat= e 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_01C3D52C.273B9780-- -- 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).
RE: ORA-1652: temp segment in tablespace SYSTEM ?!?
--_=_NextPart_001_01C3C594.461C3ED6 Content-Type: text/plain No, they weren't loading into the SYSTEM tablespace. Turned out that the AQUSER account had SYSTEM as a temp space in one of the two instances. Didn't think to check AQUSER when I checked the settings for the users running the procedure on either side of the link. Still don't know why the temp segment in SYSTEM wasn't listed in the v$session and v$sort query. This is the query I ran: SELECT b.tablespace, b.segfile#, b.segblk#, b.blocks, a.sid, a.serial#,a.username, a.osuser, a.status FROM v$session a,v$sort_usage b WHERE a.saddr = b.session_addr ORDER BY b.tablespace, b.segfile#, b.segblk#, b.blocks; Robyn -Original Message- Sent: Thursday, December 18, 2003 12:34 PM To: Multiple recipients of list ORACLE-L 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: [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). - - - - - - - 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_01C3C594.461C3ED6 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: ORA-1652: temp segment in tablespace SYSTEM ?!? No, they weren't loading into the SYSTEM tablespace. = ; Turned out that the AQUSER account had SYSTEM as a temp space in one of t= he two instances. Didn't think to check AQUSER when I checked the set= tings for the users running the procedure on either side of the link. = Still don't know why the temp segment in SYSTEM wasn't li= sted in the v$session and v$sort query. This is the query I ran: SELECT b.tablespace, b.segfile#, b.segblk#, b.blocks, a.sid, a.serial#,a.= username, a.osuser, a.status FROM v$session a,v$sort_usage b WHERE a.saddr =3D b.session_addr ORDER BY b.tablespace, b.segfile#, b.segblk#, b.bl= ocks; Robyn -Original Message- From: Guang Mei [mailto:[EMAIL PROTECTED]">mail= to:[EMAIL PROTECTED]] Sent: Thursday, December 18, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-1652: temp segment in tablespace SYSTEM= ?!? Are you sure they are not loading blobs into SYSTEM table= space? 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 do= es not understand this format, some or all of this message may not be legi= ble. --_=3D_NextPart_001_01C3C583.D0824CB6 Content-Type: text/plain hey everyone ...
ORA-1652: temp segment in tablespace SYSTEM ?!?
--_=_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 Message 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-- -- 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).
