Help! Oracle problem or my problem?

Help! I don't know whether this is an Oracle problem or my problem. The problem is this: I enlarged our database by adding another 10MB data_file to it. Our project requires frequent creating and deleting of sets of tables and views. After few loading and unloading of our database tables/views I see (from dba_free_space) that our database is all fragmented into small size of extents. Eventhough I dropped all the tables/views I created, the 10MB I added is not reclaimed into one extent but into many small size extents right next to each other. Later on when I needed an extent of a bigger size, Oracle will simply say there is none. Is this correct Oracle behavior? I am running an Oracle RDBMS of v6.0.

Any help or info is greatly appreciated!

-- 


****************************************************************************

Un Un Fu                                    Internet: un_at_gdstech.grumman.com
Disclaimer: I am solely responsible for what I am saying here!


****************************************************************************