2 Databases - the same data

From: Steitz Adolf <adolf.steitz_at_also.de>
Date: Thu, 24 Aug 2000 08:48:29 +0200
Message-ID: <39a4c5ae$0$3337@businessnews.de.uu.net>

Hello,

we're running OneWorld from J.D.Edwards.

I have now 2 tablespaces with exactly the same tables and amount of data.

The first tablespace (proddta) is 8GB.
Some initial and next extent sizes from tables of this tablespaces are changed from that, what J.D.Edwards recommend.

I made an export form proddta and an import into testdta. Size of testdta was also 8GB.
Then I changed the inital and next extent size of every table back to that, what J.D.Edwards recommends.

Then i made an export form testdta, dropped testdta, recreated testdta and made an import.
Now, testdta has 3,3 GB!!!

In my opinion, something is wrong with parameter for proddta. Otherwise I couldn't reduce the size from 8GB down to 3,3 GB.

Can anyone tellme, where i have to look.

every table has:              pctfree = 10%
                                     pctused = 40%
                                     pctincrease = 0%

WIN/NT, Oracle Version 8.0.5

Thank you!!

Adolf Received on Thu Aug 24 2000 - 01:48:29 CDT

2 Databases - the same data - different size