Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Weird - unable to extend error
actually, the problem is that the SYSTEM account still has the system tablespace as the default tablespace.
Should be changed asap.
>From: Paul Baumgartel <PaulB_at_instipro.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Weird - unable to extend error
>Date: Fri, 09 Mar 2001 06:25:43 -0800
>
>In this case the "temporary segment" was not a sort segment, but the space
>allocated for an index while under construction. I'm surprised that no one
>here caught that!
>
>
>Paul Baumgartel
>InstiPro, Inc.
>paul.baumgartel_at_instipro.com
>212 813-0829 x103 (office)
>917 549-4717 (mobile)
>
>
>-----Original Message-----
>Sent: Friday, March 09, 2001 7:17 AM
>To: Multiple recipients of list ORACLE-L
>
>
>smack your fellow DBA around for logging in as system and not his own
>id, and I still stand by my statement change the system userid temporary
>tablespace to temp.
>
>joe
> > lerobe - Lee Robertson wrote:
> >
> > Sorry Guys,
> >
> > Ignore this message. One of the other DBAs had logged in from home (he
> > gets in later in the morning than me so I never got a chance to speak
> > to him before sending this mail) and attempted to create an index on a
> > table while logged in as system
> >
> > create index user.tabind blah blah ......
> >
> > and thought by using the fully qualified schema name it would appear
> > in the TS he wanted it in.
> >
> > Ho hum
> >
> >
> > Lee Robertson
> > Acxiom
> > Tel: 0191 525 7344
> > Fax: 0191 525 7007
> > Email: lerobe_at_acxiom.co.uk
> >
> > -----Original Message-----
> > From: lerobe - Lee Robertson [mailto:LEROBE_at_acxiom.co.uk]
> > Sent: 09 March 2001 08:25
> > To: Multiple recipients of list ORACLE-L
> > Subject: Weird - unable to extend error
> >
> > 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.
>
>--
>Joe Testa http://www.oracle-dba.com
>Performing Remote DBA Services, need some backup DBA support?
>For Sale: Oracle-dba.com domain, its not going cheap but feel free to
>ask :)
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Joseph S. Testa
> INET: teci_at_oracle-dba.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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Baumgartel
> INET: PaulB_at_instipro.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_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 - 09:59:23 CST