Re: Import failure

Oscar Ssentoogo wrote:
>
> Hi
>
> When importing a large text data file using SqlLdr, after about 35000
> records (total 550000) there is a failure. Maximum Extents reached.
>
> How do I configure the database table to allow many more records to be
> imported at a go. The table size should be able to accommodate upto about
> 5 million records.
> What are the most efficient storage parameters for such a table,
> i.e. min / maxextents /next, tablespace size etc.
>
> Thanks
> Oscar

Hi,

I think you' ve created an empty and wantto populate it. Since you know the number of rows you'll import and you now the characteristics of the dta to import, you can calculate the average row-size. From the average row-size you can calculae the blocks needed to save all your rows. Make your initial extent large enough to bring all your data in.

-- 
Regards

M.Gresz    :-)