Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reorganize table

Re: Reorganize table

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 18 Apr 2002 09:23:41 -0800
Message-ID: <F001.00448357.20020418092341@fatcity.com>


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
>>> raghukota_at_hotmail.com 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: raghukota_at_hotmail.com 

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: ListGuru_at_fatcity.com (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: RROGERS_at_galottery.org

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: ListGuru_at_fatcity.com (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).
Received on Thu Apr 18 2002 - 12:23:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US