RE: Reorganize table
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" 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).
RE: Reorganize table
truncate table ; What version of Oracle are you using? You should be able to export with a where clause if you are on the right release and split it out that way Why are you reorging? What is your goal? -Original Message- Sent: Thursday, April 18, 2002 8:39 AM To: Multiple recipients of list ORACLE-L 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 worlds 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: Kimberly Smith 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).
RE: Reorganize table
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).
RE: Reorganize table
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).
Re: Reorganize table
Raghu, I think that because of your limited space you are between the rock and a hard place. Make sure you have a good BACKUP. I would even try for more than one good backup as you don't know if the backup tape was good until you try a restoral. I would try creating a table that I could load a portion of the data from the monster table, export the data from the "portion table" and then truncate the "portion table". Load the "portion table" with more data from the monster table and follow the process until all the data from the monster table has been exported. I would keep the exports on a different machine until the re-org is completed. After the data is exported you can truncate the monster table and import the data back into the "portion table" and then load the data into the monster table from the "portion table". all of you data should then be back in the monster table and fragmentation removed. I understand your situation. I have 72 GIG disk with 3 GIG free and some datafiles are 3.8 GIG with tables over 6 GIG. I am waiting to migrate to a new server some time next year. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 04/18/02 11:38AM >>> 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: Ron Rogers 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).