|
-
Hi Joe,
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.
4. Insert the rows from the copy table.
Hope this helps
Moff
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|