8i - 9i conversion tablespaces much larger after import
hi,
we are converting our databases from 8i to 9i.
We are using locally managed ts with uniform 1m.
The tablespaces on the 9i are much larger than the 8i after we import the data - and some are showing 100% used
e.g. one tablespace is used 70meg sized at 400meg so 17% used in 8i …. And after import into 9i with size 400 meg and specifying UNIFORM extent growth of 1meg, it is 100% used and is taking up 452 meg ??? - is this anything to do with uniform, or is it something to do with 9i tablespaces? - we would have to allocate a lot more disk space if this is going to happen, and we do not have a lot of spare space presently. I just do not understand why the tablespace has so much more used space in 9i version - should I have chosen the compress option in the exp/imp etc and would this have made any difference to the physical data anyway?
here is the create tablespace command
CREATE TABLESPACE ENTPER
DATAFILE SIZE 400M
AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1M
ONLINE
PERMANENT;
also, should we make the SYSTEM tablespace locally managed or leave it Dictionary managed?