Hi guys,

I have set up a new database, and prepare for a migration with export/import.
I set up the tablespaces following the SAFE(Simple Algorithm for Fragmentation Elimination) recommendations, so I use PCTINCREASE 0.

Now I see that after import the tables have specified storage clause, and in another hand I know that with a PCTINCREASE 0 at tablespace level, SMON will not COALESCE the free space.

Question 1. If there are pctincrease other than 0 at table level when it's 0 at tablespace level, smon will coalesce the free space?

The system have more than 500 tables, so I wonder if
1. it's worth to truncate all tables, edit all table definition and import just the rows, or
2. I have to change the pctincrease at tablespace level or
3. do nothing, SMON work anyways because pctincrease is not 0 at table level.


Thanks for any input,
marian