Re: Database size increase on Oracle 9i

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?

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
>
Received on Thu Nov 15 2001 - 13:41:04 CST