Re: Segment_type = TEMPORARY

select username, temorary_tablespace from dba_users;

...and see who is using the non-temp tablespace for their temporary (or to verify that this is not the case). Then physically find the user and beat them about the head and shoulders!!!

Oh yeah, you may want to alter the user to the correct temp ts.

Scott Shafer
San Antonio, TX

• Original Message ----- From: "Luc Demanche" <lucdemanche_at_hotmail.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 07, 2000 4:45 PM Subject: Re: Segment_type = TEMPORARY

> It`s weird because isn't in my temporary tablespace .
>
> Any ideas
>
>
> >From: paquette stephane <stephane_paquette_at_yahoo.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Segment_type = TEMPORARY
> >Date: Wed, 07 Jun 2000 10:00:46 -0800
> >
> >Those are temporary segments.
> >They should belong to the temp tablespace, they are
> >created whenever Oracle needs temp space to sort.
> >
> >
> >
> >--- Luc Demanche <ldemanch_at_cetelem.fr> a écrit : > Hi
> >all,
> > >
> > > I found 3 segments in dba_segments table with the
> > > segment_type =
> > > TEMPORARY.
> > >
> > > What's the meaning of segment_type = TEMPORARY. Did
> > > oracle create this
> > > ?
> > >
> > > TIA
> > >
> > > --
> > > Author: Luc Demanche
> > > INET: ldemanch_at_cetelem.fr
> > >
> > > 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).
> >
> >
> >=====
> >Stephane Paquette
> >DBA Oracle
> >stephane_paquette_at_yahoo.com
> >spaquette_at_houra.fr
> >(33) 01 53 93 06 50
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Yahoo! Photos -- now, 100 FREE prints!
> >http://photos.yahoo.com
> >--
> >Author: =?iso-8859-1?q?paquette=20stephane?=
> > INET: stephane_paquette_at_yahoo.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).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Luc Demanche
> INET: lucdemanche_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
Received on Wed Jun 07 2000 - 16:26:08 CDT