I generally create three or four tablespaces based on object sizes. For each tablespace, I use local extent management with extents of uniform sizes -- one size per tablespace, usually 128 KB, 4 MB, 16 MB and 64 MB. Objects are assigned to tablespaces based on their sizes. Specifying uniform extent sizes means that free space within a tablespace can always be reused, as every object's extents are the same size.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Paul Baumgartel
I am updating 80% of the rows in a 30-column (6 VC  and a blob) table. I have the STD 10% pctfree set up. I am getting fair throughput,... Continue Reading
We are starting to upgrade to Oracle 10g and support a PeopleSoft application on AIX5L. Which initialization parameters do you consider important for... Continue Reading
Can I install the Oracle 8i client and the Oracle 10g client on Windows XP? Continue Reading