I have just taken over a 10GB database and on analyzing a few key tables, I find that the intial extent sizes range from 50-70MB. It is an OLTP application and I think that such big extent sizes are not good.

How do I go about fixing this problem? Export table and import it into a new table withh appropriate extent sizes? What happens to the associated indexes/views?

Thanks,
Nizar.