| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Weird - unable to extend error
Oh man, You did't change using SYSTEM temp to TEMP tablespace, You to assing what ever users from system to temp as default temporary tablespace, Other wise you have big problem. Only sys and system can use SYSTEM temp segments.
Raghu.
>From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Weird - unable to extend error
>Date: Fri, 09 Mar 2001 00:25:27 -0800
>
>Oracle 8.0.5.0.0
>Tru64 4.0f
>
>Got in this morning (duh duh duh duh)
>and found a mail from my alerting script from the DB with the following
>
>ORA-1652: unable to extend temp segment by 27309 in tablespace
> SYSTEM
>
>As far as I am aware there was absolutely nothing going on on this system
>and indeed was the first entry in the alert log file for about 2 hours.
>(Normal operations on this DB stop at about 18:00 - the message appeared at
>20:20.).
>
>Should I be worried ?? There have been no entries in the alert log since.
>(saying that though, people don't start using it until about 9am).
>
>Lee Robertson
>Acxiom
>Tel: 0191 525 7344
>Fax: 0191 525 7007
>Email: lerobe_at_acxiom.co.uk
>
>
>
>
>The information contained in this communication is
>confidential, is intended only for the use of the recipient
>named above, and may be legally privileged. If the reader
>of this message is not the intended recipient, you are
>hereby notified that any dissemination, distribution or
>copying of this communication is strictly prohibited.
>If you have received this communication in error, please
>re-send this communication to the sender and delete the
>original message or any copy of it from your computer
>system.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: raghukota_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_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).Received on Fri Mar 09 2001 - 10:25:53 CST
 |
 |