[GDAL-DEV] ogr2ogr -f "ESRI Shapefile" - problem

[Frank Warmerdam]

abhay menon wrote:
> Hello List,
>  
> recently was trying to extract shapefiles from an oracle database in 
> batch mode
> it seem that ogr2ogr is not allowing to create shapefile more 168 in 
> numbers.
>  
> i gave a simple instruction through the command line in same folder but 
> the operation was terminated by saying
> *"D:\batch1\xyz169.DBF file could not be created"*
> where as the xyz169.shp and xyz169.shx where created.
> also did the same by changing the folder name it was successfully 
> created. so changed my logic in the batch mode operation creating 
> temporary place and  moving it to the actual folder.
>  
> I am puzzled by the fact that why ogr2ogr failed in creating the 
> shapefiles more than 168 in the same folder. Is it a limitation of the 
> shapefile or is it set nature of the DBF file that not more than 168 
> number file could be created at one folder in one go??

Abhay,

3 * 168 is 504.  I suspect you have a limit of 512 open files at a time on
your system and that this has been hit with the 168's shapefile set and
a few other files (ie. oracle connections).  I imagine you could invoke
ogr2ogr on one layer at a time and things would be ok.

Some operating systems also provide mechanisms to increase the maximum
number of open file descriptors.  I have no clue if or how this is possible
on windows.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGF, http://osgeo.org