| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: quick question on decompressing a table...
I forgot to mention it's 9203 on HP.
The reason we chose this way is because a LARGE percentage of the existing rows are chained. ...i'm not too concerned about it, but the other dba is.
...one drawback to what I suggested is that (from what I understand) owb croaks when an object's id changes. ...so there is extra work on that side too.
-----Original Message-----
From: Freeman Robert - IL [mailto:FREEMANR_at_tusc.com]
Sent: Wednesday, February 18, 2004 4:38 PM
To: 'Chris Stephens '; 'oracle-l_at_freelists.org '
Subject: RE: quick question on decompressing a table...
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_at_freelists.org
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |