You can export and compress on the fly.... This unix... mknod export_pipe p compress < export_pipe > export_file.dmp.Z & exp userid .... file=export_pipe log=export.log table=(big_fat_table) .... compress=n
Try it. I hope it compress to less than 5G. -----Original Message----- Sent: Thursday, April 18, 2002 10:19 AM To: Multiple recipients of list 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: Wong, Bing 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).