Mark, We are using Direct loads. Freek, I think we are hitting on this bug. Thanks, Vamshi .D On Fri, May 28, 2010 at 11:29 AM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx>wrote: > Hi, > > I had a client with a similar problem, which turned out to be bug 5987262. > Can you check mos note "Table/Index (partition) Growth Is Far More Than > Expected [ID 729149.1]" to verify if you hit the same bug? > > > Regards, > > > Freek D'Hooge > Uptime > Oracle Database Administrator > email: freek.dhooge@xxxxxxxxx > tel +32(0)3 451 23 82 > http://www.uptime.be > disclaimer: www.uptime.be/disclaimer > ________________________________________ > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Vamshi Damidi > Sent: vrijdag 28 mei 2010 17:18 > To: Warren Puziewicz > Cc: oracle-l@xxxxxxxxxxxxx > Subject: Re: Tablespace growing like anything and free blocks not > reutilized. > > My ETL code doesnt use this option APPEND. > and 50% of time we use SQLLDR to migrate data from mysql to oracle to get > old data. > > Thanks, > Vamshi .D >