Is the table partitioned?
Also, do you have any money for reorg tools? What sort of maintenance window do you have to complete this reorg? Can you negotiate for a larger-than-normal maintenance window? Cherie "Koivu, Lisa" <lisa.koivu@efair To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> field.com> cc: Sent by: Subject: RE: Reorganize table [EMAIL PROTECTED] 04/18/02 12:18 PM Please respond to ORACLE-L If you can't export, can you do ctas (create table as select..) ? Either way it's going to take a long, long time... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 > -----Original Message----- > From: Raghu Kota [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > Subject: Reorganize table > > > > Hi Friends, > > I need to reorganize my big fat table sized 23Gb, I don't have much space > for export on my filesystem( I keep one or two filesystems ready for my > expansion each size 4Gb) in the same table I have more than 5Gb free > fragmented space, But I can't use it!! So what is best way to reorganize > this monster table?? > > Thanks in advance > Raghu. > > > > _________________________________________________________________ > Join the world's largest e-mail service with MSN Hotmail. > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).