From JTESTA@longaberger.com Tue, 03 Jul 2001 08:06:03 -0700 From: "JOE TESTA" Date: Tue, 03 Jul 2001 08:06:03 -0700 Subject: Re: temp resize? Message-ID: MIME-Version: 1.0 Content-Type: text/plain sure by dropping the temp tablespace, rm(del for you windoze abusers), and create the tablespace back.   joe   >>> raghukota@hotmail.com 07/03/01 11:10AM >>>Hi FriendsI need to rebuild the Indexe of 6Gb size. For that When Iam doing rebuild option Its saying temp space insufficent!! So right now my temp tablespace size 1.75Gb spreading around 4 datafiles across two disks, I can't touch theose disks because of full. So I need to add another datafile/files to support my rebuild for that I need to increase temp tablespace, But can I bring it back to orignial 1.75Gb??? of temp tablespace after my rebuild is completed.Thanks for your responses.Raghu._________________________________________________________________________Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Raghu Kota  INET: raghukota@hotmail.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).