RE: Temporary tablespace for SYS

The sort_area_size was enough to get it done.

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Wednesday, September 13, 2000 6:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Temporary tablespace for SYS

after dropping the temp tbs for used for SYS, i ran an sql with group by and order by... but no errors returned !! then i did a simple equi join of two tables... and error ....ORA-00959: tablespace 'TEMP' does not exist

why this error was not returned for the "group by" and "order by" clause ?

Rahul

> ----------
> From: Rachel Carmichael[SMTP:carmichr_at_hotmail.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, September 13, 2000 5:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Temporary tablespace for SYS
>
> why would it change that information? All that will happen is SYS will get
>
> errors when trying to use the tablespace.
>
> Steve -- I have dropped tablespaces that have been used by SYS.. whoever
> wrote that note was mistaken.
>
> Rachel
>
>
> >From: Rahul <rahul_at_ratelindo.co.id>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: Temporary tablespace for SYS
> >Date: Tue, 12 Sep 2000 19:35:29 -0800
> >
> >i just did it... but it did not change the TEMPORARY_TABLESPACE
> >info in dba_users for SYS !!!
> >
> > > ----------
> > > From: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> > > Sent: Tuesday, September 12, 2000 7:29 PM
> > > To: main oracle list; oracle dba list
> > > Subject: Temporary tablespace for SYS
> > >
> > > Hi All,
> > >
> > > I've got an email from someone who says that it used not to be
> possible
> >to
> > > drop
> > > a tablespace that had ever been the temporary tablespace for SYS. This
>
> >is
> > > news
> > > to me. Has anyone ever heard of this before?
> > >
> > > @ Regards,
> > > @ Steve Adams
> > > @ http://www.ixora.com.au/
> > > @ http://www.christianity.net.au/
> > > @
> > > @ Going to OpenWorld?
> > > @ Catch the Ixora performance tuning seminar too!
> > > @ See http://www.ixora.com.au/seminars/ for details.
> > >
> > >
> > > --------
> > > If you're bored, then visit the list's website: http://www.lazydba.com
> > > (updated daily)
> > > to unsubscribe, send a blank email to
> >oracledba-unsubscribe_at_quickdoc.co.uk
> > > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> > >
> >--
> >Author: Rahul
> > INET: rahul_at_ratelindo.co.id
> >
> >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.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.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).
>

-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

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