WE just migrated our database from 8.0.5 to 22.214.171.124 using the migration utilities.
We also migrated our context catridge in the database to intermedia at the same time.
Now before we make the database live I want to reoranize the tables using export import because most of them have more than 10 extents. Infact some even have 100's.
The system tables also have many extents.
Doing a export/import fixes the problem.
I know the steps require to do a full import but am not sure how exactly should i go about minimising the extents or fitting the objects to one extent.
Will just a simple export import do or I need to do something else also to fix this problem.
What should I do to take some proactive measures so that this does not happen again.
You can if you think you can.