Import failure

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 Received on Mon Sep 01 1997 - 00:00:00 CDT