Re: temp resize?

[JOE TESTA]

sure by dropping the temp tablespace, rm(del for you windoze abusers), and create the tablespace back.   joe   >>> [EMAIL PROTECTED] 07/03/01 11:10AM >>> Hi Friends I 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: [EMAIL PROTECTED] 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: [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).