Re: extent blowout

jabs wrote:

> I'm loading data into a 9i database (9.2) using PL/SQL for a data warehouse.
> We are using local tablespaces (128mb in this case). When I load particular
> tables, they use many more extents than they should be. I can move the
> tablespace to somewhere else, move it back, and it's less than half the
> size.
>
> The PL/SQL map is very simple logic. I've rebuilt the table without
> specifying initial/next parameters, - since it's a truncate/insert, I
> specified pctfree 2 <I've also tried 10>. There are no indexes on the table.
> The dbas I'm working with haven't come up with anything yet.
>
> TIA, and let me know if you need more info. Thanks again!
>
> jabs.

The DDL that built the tablespace and the DDL that built the table would be very useful.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)