i removed the sort_area_size param from the init.ora.. the default size was
64K !! and i ran the groupby order by on a 3 million row table !!
> ----------
> From: Khedr, Waleed[SMTP:Waleed.Khedr_at_FMR.COM]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, September 14, 2000 2:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Temporary tablespace for SYS
>
> The sort_area_size was enough to get it done.
>
> -----Original Message-----
> Sent: Wednesday, September 13, 2000 6:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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
Received on Wed Sep 13 2000 - 21:17:42 CDT
