Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Weird - unable to extend error

RE: Weird - unable to extend error

From: Paul Baumgartel <PaulB_at_instipro.com>
Date: Fri, 09 Mar 2001 09:12:48 -0800
Message-ID: <F001.002C85FF.20010309081144@fatcity.com>

I'm not so sure.

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 9:55 AM
To: Multiple recipients of list ORACLE-L

Sorry Paul,

Do not pass Go and do not collect 200 quid. One of the other guys in here had logged in as system and was creating an index, his temporary tablespace was set to SYSTEM and therefore Joe's diagnosis below was correct.

> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>

-----Original Message-----
Sent: 09 March 2001 14:26
To: Multiple recipients of list ORACLE-L

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: lerobe - Lee Robertson
  INET: LEROBE_at_acxiom.co.uk

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).
Received on Fri Mar 09 2001 - 11:12:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US