Re: Help with SQL*Loader - Error 605

Hi,

Take care that SQL*LOADER partially
rollback before exiting (but not all),
so, you can't see all extents needed.

Special care with indexes storage
clause : if tables are empty before
loading, I prefer to load without
indexes. Indexes works better when
created with data loaded (even if this
take time to create)

It seems to bo the good way.

-- 
REIP Jean-Claude
jacari.consultant_at_skynet.be

Michael Serbanescu
<mserban_at_postoffice.worldnet.att.net> a
écrit dans l'article
<33E96489.5D55_at_postoffice.worldnet.att.n
et>...


> You've exceeded the maximum number of

 extents for the table, or for one


> (or several) of the indexes on the

 table. Try this query to check the


> number of extents for table/indexes:

> 

> It is also possible that you have run

 out of space in the DATA or INDEX


> tablespaces (if this is the case, try

 to use the AUTOEXTEND feature).


> 

> Michael Serbanescu

>

----------------------------------------
-------------------------------


> teamone wrote:

> > 

> > I am using SQL loader to load data

 into an Oracle 7.3 Workgroup server


> > running on Windows NT.  After

loading about 160,000 records loading
stopped


> > with the following error.  I

 checked for sufficient tablespaces.


> > 

> > SQL*Loader - 605 Non-data dependent

 error.


> > 

> > Any help is appreciated.


>