In 9i you could issue an "drop tablespace temp including contents and datafiles". (First make sure that this tablespace is not a default temporary tablespace).
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 5:54 AM > What is the Oracle version? > > At 06:24 PM 9/30/2003 -0800, you wrote: > >Hi!! > >I am trying to change the size of my tablespace TEMP, I am not an > >Administrator but we really need to make this tablespace smaller. > >Already the size is 13214 Mgs, and this tablaspace is on a disk that is > >full, so if we can not make it smaller we are going to be in a serius > >trouble ( our Administrator is not here until Monday). > > Wolfgang Breitling > Centrex Consulting Corporation > http://www.centrexcc.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Wolfgang Breitling > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
