Heck, I have been around a while and I either did not know that or I = have forgotten. I do that a lot. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Connor McDonald Sent: Thursday, February 19, 2004 4:35 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: quick question on decompressing a table... Slightly related but common trap for new players. alter table X move nologging; will move a table WITH logging and then set it to NOLOGGING. Probably = not what is intended. Cheers Connor --- Tanel_P=F5der <tanel.poder.003@xxxxxxx> wrote: > If you want to decompress the existing blocks as well, then you can just use > "alter table move nocompress", with nologging and parallel if you = want. (but > test it out on a test table first, I had some problems with it in 9.2.0.1). >=20 > Tanel. >=20 > ----- Original Message -----=20 > From: "Freeman Robert - IL" <FREEMANR@xxxxxxxx> > To: "'Chris Stephens '" <ChrisStephens@xxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> > Sent: Thursday, February 19, 2004 12:38 AM > Subject: RE: quick question on decompressing a table... >=20 >=20 > > Someone might disagree with me, but it strikes me that this is = *much* more > > work than it's worth. Simply alter the table to not use = compression. New > > data will not be compressed and While the data thats in it right = now might > > be in compressed format, any change to that data will result in = it's > > permenant uncompression. Since there isn't much data in it at this point, > I > > would not think that this would be that big of a deal.... > > > > RF > > > > -----Original Message----- > > From: Chris Stephens > > To: oracle-l@xxxxxxxxxxxxx > > Sent: 2/18/2004 4:33 PM > > Subject: quick question on decompressing a table... > > > > We have a fact table that was mistakenly created with the = compression > > option. > > Fortunately there is not (too) much data in the table as of yet. > > > > The table is partitioned and have bitmap indexes on all the foreign > > keys. > > > > Downtime isn't a huge deal...but minimizing it would be a positive > > thing. > > > > > > > > The easiest way I can think of to correct this is the following: > > > > > > > > Create table temp as select * from comp_table nologging; > > > > > > > > Drop table comp_table; > > > > > > > > Recreate table comp_table > > > > > > > > Insert /*+ append */ into comp_table select * from temp_table; > > > > > > > > Rebuild bitmaps > > > > > > > > Regrant privileges. > > > > > > > > > > > > ...any faster/easier way to do this? ...any gotchas working with > > compressed tables (not sure how it would relate to this situation)? > > > > ...I'm no expert on table compression and as it stands now, r'ing = tfm > > at > > this point isn't won't be worth any time savings. I'm mostly just = (a > > little) curious. > > > > > > > > Thanks for any suggestions > > > > Chris > > > > > > > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > >=20 >=20 > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > -----------------------------------------------------------------=20 =3D=3D=3D=3D=3D Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" - available = now web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@xxxxxxxxx "GIVE a man a fish and he will eat for a day. But TEACH him how to = fish, and...he will sit in a boat and drink beer all day" =09 =09 =09 ___________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping"=20 your friends today! Download Messenger Now=20 http://uk.messenger.yahoo.com/download/index.html ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------