Re: Database size increase on Oracle 9i

Stephen Carviille wrote:
>
> Connor McDonald wrote:
>
> > 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"?
>
> According to the DBA he exported the data from the 8i database on the
> Solaris machine, copied the files to the Linux box, and imported the data
> into the 9i database.
>
> > 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
> >

Well - he did something wrong :-)

I would investigate storage definitions and/or tablespace management changes..

hth
connor

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

http://www.oracledba.co.uk

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