uniform size and AUTOALLOCATE
694352Jun 3 2009 — edited Jun 18 2009Hello
I took a full export from oracle 7 and tried to full mport into new 9i database.
The size of oracle 7 is 15G.
Before the import process I created tablespaces with uniform size 32M,
then I start the import process and notice that the size of the database increased enormously.
The total used size of the entire tablespaces was 25G!!!! Eventually I run out of space.
Then I dropped all tablespaces and recreated them with default oracle AUTOALLOCATE.
And reimport.
The entire size is normal now(around 16G),not much diffrence with the db that I exported.
What is the reason for this?