If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

A bunch of our fact tables were created w/ PCT_FREE = 10.
The rows in these tables never get updated. We have lost a TON of space (200MB in a 2GB * 160 files) and I would like to reset PCT_FREE to 0. Is there a way to reclaim the space and reset the value w/o having to do a full export and reimport?

When you change the PCTFREE parameter for a table the new settings apply
to all data blocks used by the table. However blocks already allocated are not
immediately reorganised but as necessary after change. If you are not making
changes to the table or require the space to be reclaimed immediately then
I believe an export/import is one option. Another way (which may be quicker)
but would require double the disk space is:

1. Create a copy of the table using
'Create table copytable as (select * from origtable)'

2. Drop the original table.

3. Create a table (using the original table name) with the correct
storage parameters.