RE: Odd Temp tablespace error

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Thu, 26 Oct 2000 15:09:28 -0700
Message-Id: <10661.120362@fatcity.com>

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_01C03F99.68F617B0
Content-Type: text/plain

Does anyone have USERS as their default tablespace? One of your losers...I mean users is trying to create an object within the USERS tablespace and when Oracle tries to create the object, it bombs out.

Regards,
Satar

> -----Original Message-----
> From: blair_at_pjm.com [SMTP:blair_at_pjm.com]
> Sent: Thursday, October 26, 2000 9:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Odd Temp tablespace error
>
> Oracle 8.0.5
>
> My alertlog has an occasional entry that says "ORA-01652 Unable to extend
> temp
> segment by 192 in tablespace USERS."
>
> But if I select temporary_tablespace, username from sys.dba_users - no
> user has
> USERS as its temporary_tablespace. How is this happening?
>
> ..tom
>
>
>

------_=_NextPart_001_01C03F99.68F617B0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Odd Temp tablespace error</TITLE>
</HEAD>
<BODY>

Does anyone have = USERS as their default tablespace?  One of your losers...I mean = users is trying to create an object within the USERS tablespace and = when Oracle tries to create the object, it bombs out.

Regards, Satar

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">blair_at_pjm.com [SMTP:blair_at_pjm.com]</FONT>

Sent:   Thursday, October 26, 2000 9:06 PM To:     Multiple recipients of list ORACLE-L Subject:       = Odd Temp tablespace error

Oracle 8.0.5

My alertlog has an occasional entry = that says "ORA-01652 Unable to extend temp segment by 192 in tablespace = USERS."

But if I select temporary_tablespace, = username from sys.dba_users - no user has USERS as its = temporary_tablespace.  How is this happening?

..tom Received on Thu Oct 26 2000 - 17:09:28 CDT