Re: Database size increase on Oracle 9i

Stephen Carviille wrote:
>
> I am testing Oracle 9i on Linux and after migrating one of our database
> from oracle 8i on Solaris to the Linux server the DBA reports the size of
> the data base increased about three-fold! On Solaris 8 and Oracle 8i the
> data base is about 5.6 G but on the Linux server it is 16 G.
>
> I'm just a lowly sysadmin :-) and have no idea how this could happen. Any
> suggestions on where to start looking? Or is this a normal thing?

What do you mean by "migrate"?

You don't need to unload/reload the database to go from 8 to 9. If you have done an unload/reload, then I would have a look at some of your storage definitions etc - its possible to get some growth if you've gone from dictionary to locally managed tablespaces due to rounding

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."